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. Your advice, or pointing me to the proper documentation, would be greatly appreciated! Thanks, Daniel