Re: [sqlite] "Data Dictionary" in SQLite?

2005-09-21 Thread Gerry Snyder
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 t

Re: [sqlite] "Data Dictionary" in SQLite?

2005-09-21 Thread Ramon
>From what I know sqlite is not a DBRMS Thanks > 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

Re: [sqlite] "Data Dictionary" in SQLite?

2005-09-21 Thread Kurt Welgehausen
pragma table_info (and others). Look at the pragma docs. Regards

Re: [sqlite] "Data Dictionary" in SQLite?

2005-09-21 Thread Jay Sprenkle
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"

[sqlite] "Data Dictionary" in SQLite?

2005-09-21 Thread Daniel Hutchison
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,