Code:
DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]
DROP TABLE removes one or more tables.
You must have the DROP privilege for each table.
All table data and the table definition are removed,
so be careful with this statement!
U manualu lijepo pise :)
Dakle, trebas kucati:
Code:
DROP TABLE tabela1, tabela2, tabela3;
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA