| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Drop table
Is there a way how to drop a table in Oracle DB, but I'd like to check
if this table alredy exists in database?
Something like this:
if exists(select * from user_tables where table_name='mytable') then
drop table mytable;
end if;
but I can't use DDL statements.
ThanX.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 21 2000 - 04:10:46 CST
 |
 |