sqlite query table names

From thelinuxwiki
Jump to: navigation, search

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