Daniel Hutchison wrote:
Is there an Oracle data-dictionary equivalent in SQLite?
Ie. Is there something similar to "SELECT * FROM ALL_TABLES" to get
information about tables in the database returned in row format?
Daniel,
The other replies were not bad, but the query closest to what you are
asking for is, I think:
select name from sqlite_master where type='table'
if you want just the table names. If you want the full info, such as
field names, use:
select sql from sqlite_master where type='table'
Gerry
--
------------------
Gerry Snyder
American Iris Society Director, Symposium Chair
in warm, winterless Los Angeles -- USDA zone 9b, Sunset 18-19
