Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: if table exists (DBI)

by Chief of Chaos (Friar)
on Nov 17, 2002 at 09:59 UTC ( [id://213535]=note: print w/replies, xml ) Need Help??


in reply to if table exists (DBI)

Hi,
I only know these ways :
List names of all tables and views After the connection to Oracle or Sybase or MySQL has been established, the names of all tables and views that belong to the user are displayed. User can then select one by clicking it (single selection). The list of tables and views is retrieved by using the following queries: (1) Oracle: select table_name from user_tables; select view_name from user_views; (2) Sybase: select sysobjects.name from sysusers, sysobjects where sysobjects.uid=sysusers.uid and (sysobjects.type='U' or sysobjects.type='V') and sysusers.name='XXX'; (3) MySQL: show tables; Note that MySQL does not support views.

From : http://www.cslab.uky.edu/~jgao0/mproj/help.txt

I hope this may help you

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://213535]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (2)
As of 2024-04-26 05:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found