Re: Checking if a table exist

[JupiterHost.Net]

Reidy, Ron wrote:

1.  Look in the data dictionary
2.  Select from the table and trap the appropriate error code

-----Original Message-----

From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 4:33 PM

To: List - DBI users
Subject: Checking if a table exist

Hi All,

Does anyone know of a good way to check if a table exist disregarding

whether the table has data or not?

put 'SHOW TABLES;' into a hash and
if(exists $tables{'user'}) {

...