Re: Checking if a table exist
- From: mlists@xxxxxxxxxxxxxxx (JupiterHost.Net)
- Date: Fri, 28 Apr 2006 10:27:18 -0500
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:Peter.Loo@xxxxxxxxxxxxxxxxxxxxxxxx] 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'}) {
....
.
- References:
- RE: Checking if a table exist
- From: Ron Reidy
- RE: Checking if a table exist
- Prev by Date: RE: Checking if a table exist
- Next by Date: problems getting Hebrew strings from Oracle
- Previous by thread: RE: Checking if a table exist
- Next by thread: dbi.perl.org isn't working all that great
- Index(es):
Relevant Pages
|
