Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I check is a table object exist ?
Message
 
 
To
03/10/2001 14:35:56
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00563779
Message ID:
00563795
Views:
19
>Hello everyone,
>
>I am writing a script and I'd like to kwow if a table exist before I drop it.
>Any help is appreciated.
>
>Thanks,
>Sergio

You can use the SPT function SQLTables() to return a cursor of table names available to the currently connected User schema.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform