drop table statement code example

Example 1: drop table

DROP TABLE table_name;

Example 2: sql drop table

-- Drop, but no space gain
DROP TABLE table_name;
-- Really frees space (Oracle)
DROP TABLE table_name PURGE;