Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verify if exist a table in a database
Message
De
02/09/2002 00:28:28
Wilfred Chan
Bnp Paribas Hong Kong Branch
Hong Kong, Hong Kong
 
 
À
30/08/2002 15:42:12
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00695535
Message ID:
00695874
Vues:
14
This message has been marked as the solution to the initial question of the thread.
Hi,

You can see two tables:
ALL_objects: all objects
User_objects: User owned objects
e.g. select * from user_objects where object_type='TABLE' and ....

Type DESC [table name] to see the columns of a table.

:) Wilfred

>Hello *.*
>
>How can I do to say if a table exists in my database ?
>
>With SqlServer I use: select * from sysobjects
>
>And with ORACLE ???
>
>Thank you all!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform