select * from sqlite_master; A column tells the type of object.
On 9/21/05, Daniel Hutchison <[EMAIL PROTECTED]> 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? I know > that I can use .tables or .dump to find out what is going on in the > database, but I have a programmatic need to be able to detect if a > particular table exists. >