How to check the existence of a table?

From: xiaohuwang@xxxxxxxxxxx (Yu Wang)
Date: Sun, 22 May 2005 17:29:40 +0000 (UTC)

I use DBD::SQLite as my database and I am wondering if there is any function
that checks the existence of a table?

Or, how to list all the tables in a SQLite database using DBI?

Thanks a lot!

.

Follow-Ups:
- Re: How to check the existence of a table?
  - From: Yu Wang

Prev by Date: Version 1.42 of DBD::Pg released
Next by Date: Re: How to check the existence of a table?
Previous by thread: Version 1.42 of DBD::Pg released
Next by thread: Re: How to check the existence of a table?
Index(es):
- Date
- Thread

Relevant Pages

Re: What is a surrogate identifier
... The "existence" of an address is something we rarely deal with. ... Springfield IL is an "undeliverable address". ... Presuming that the database behind the USPS website is accurate in this ... That's quite different from simply asserting that "such an address ...
(comp.databases.theory)
Re: a union is always a join!
... that permanently identifies the thing in the universe of discourse ... to express the contents of a database change, ... to me why you don?t use basic terms from relational model or maybe ... Something comes into existence at the beginning of an interval, ...
(comp.databases.theory)
Re: Rebuilding EDB From Log Files
... you mean you have every transaction log that was ever generated? ... never perform a backup? ... how long has that database been in existence? ...
(microsoft.public.exchange.admin)
Re: Rebuilding EDB From Log Files
... you mean you have every transaction log that was ever generated? ... never perform a backup? ... how long has that database been in existence? ...
(microsoft.public.exchange.misc)
UPDATE using a join and NOT EXISTS?
... I have two tables in a database, one of which I'm trying to update ... based on the existence of data in the other. ... flag whether or not the task is complete. ... SET TaskComplete = 1 ...
(microsoft.public.sqlserver.programming)