drop and create table sql code example

Example: sql drop table

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