Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: to avoid errors while dropping not existing objects
Your best bet in this case is to query the system tables. Check out
the User_Tables table.
So, Select count(*) from User_Tables where Table_Name = '<Your TableName>'
Note that Your TableName is case sensitive. If the result is greater than 0, it exists, else it does not
Documentation:
http://www.eveandersson.com/writing/data-model-reverse-engineering
Received on Tue Oct 10 2006 - 09:49:13 CDT