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
>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
pragma table_info (and others).
Look at the pragma docs.
Regards
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"
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,
5 matches
Mail list logo