how to erase table in sql code example

Example 1: delete table sql

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;