Search notes:
SQL: DROP TABLE
The purpose of the
drop table
statement is to destroy a
table
.
DROP TABLE tab;
IF EXISTS
Some RDBMS have the extension
if exists
to the
drop table
statement in which case no error message is produced if a table does not exist.
Among these are
MySQL
SQL Server
SQLite
Oracle
, since
release 23c
.
In contrast,
Oracle SQL
does not have such a clause (18c).
Index