Re: How to check the existence of a table?

From: xiaohuwang@xxxxxxxxxxx (Yu Wang)
Date: Sun, 22 May 2005 18:58:00 +0000 (UTC)

Yu Wang <xiaohuwang <at> hotmail.com> writes:

>
> 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!
>
>

Solved：

$dbh->tables(undef, undef, 'table_name', undef)

.

References:
- How to check the existence of a table?
  - From: Yu Wang

Prev by Date: How to check the existence of a table?
Next by Date: Re: db or file access?
Previous by thread: How to check the existence of a table?
Next by thread: Re: db or file access?
Index(es):
- Date
- Thread

Relevant Pages

problem using table_info and column_info with DBD::Proxy
... print STDERR Dumper; ... It works with a direct database connection. ... # Testing problem with LISTFIELDS and column_info ...
(perl.dbi.users)
Re: problem using table_info and column_info with DBD::Proxy
... How would you recommend connecting to a mysql database on a different machine? ... print STDERR Dumper; ...
(perl.dbi.users)
Re: Data structure problem to solve Linux memory fault
... contents of a database table into a lookup hash. ... To build a single lookup data structure prior to writing to a lookup ... 'B3' => undef, ...
(comp.lang.perl.misc)
Re: MySql +DBI problem
... $query=new CGI; ... undef $ln; ... # Disconnect from the database. ... 141 (hint, hint). ...
(comp.lang.perl.misc)
How to check the existence of a table?
... that checks the existence of a table? ... how to list all the tables in a SQLite database using DBI? ... Prev by Date: ...
(perl.dbi.users)