When you remove a table, all data in the table is automatically deleted as part of the dropping process. All indexes and keys
for the table are dropped as well.
Use the IF EXISTS clause if you do not want an error returned when the DROP TABLE statement attempts to remove a table that
does not exist.
You cannot execute a DROP TABLE statement when the statement affects a table that is currently being used by another connection.
Execution of a DROP TABLE statement is also prevented if there is a materialized view dependent on the table.
When you execute a DROP TABLE statement, the status of all dependent regular views change to INVALID. To determine view dependencies
before dropping a table, use the sa_dependent_views system procedure.
Automatic commit. DROP TABLE may also cause an automatic checkpoint. Clears the Results tab in the Results pane in Interactive SQL. Executing a DROP TABLE statement closes all cursors for the current connection.
You can use the DROP TABLE statement to drop a local temporary table.
SQL/2008
DROP TABLE is a core feature of the SQL/2008 standard. The IF EXISTS clause is a vendor extension. The ability to drop
a declared local temporary table with the DROP TABLE statement is a vendor extension.