To check if a Table exists in SQLite you can use the following snippet.
SELECT name FROM sqlite_master WHERE type='table' AND name='TableName'; -- temp tables can be selected by using ... FROM sqlite_temp_master ...
5 thought on “How to check if a Table exists in SQLite”
Leave a Reply
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to check if a Table exists in #SQLite http://t.co/3rlxYOElyP #sql #db #databases #database #codesnippets #coding #…
RT @CodeSnippetsNET: How to check if a Table exists in #SQLite http://t.co/3rlxYOElyP #sql #db #databases #database #codesnippets #coding #…
RT @CodeSnippetsNET: How to check if a Table exists in #SQLite http://t.co/3rlxYOElyP #sql #db #databases #database #codesnippets #coding #…
RT @CodeSnippetsNET: How to check if a Table exists in #SQLite http://t.co/3rlxYOElyP #sql #db #databases #database #codesnippets #coding #…
RT @CodeSnippetsNET: How to check if a Table exists in #SQLite http://t.co/3rlxYOElyP #sql #db #databases #database #codesnippets #coding #…