Difference between revisions of "sqlite query table names"
From thelinuxwiki
(Created page with "use sqlite_master db sqlite> select name from sqlite_master where name LIKE 'use%'; category:sqlite") |
|||
| Line 1: | Line 1: | ||
use sqlite_master db | use sqlite_master db | ||
| − | sqlite> select name from sqlite_master where name LIKE ' | + | sqlite> select name from sqlite_master where name LIKE 'string%'; |
| + | |||
| + | where sting = text you looking for to start the table name and % = wildcard for remaining part of the name | ||
[[category:sqlite]] | [[category:sqlite]] | ||
Latest revision as of 01:02, 15 May 2019
use sqlite_master db
sqlite> select name from sqlite_master where name LIKE 'string%';
where sting = text you looking for to start the table name and % = wildcard for remaining part of the name
