DROP table column in sql code example

Example 1: alter table delete column

ALTER TABLE "table_name" DROP "column_name";

Example 2: sql drop table

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

Example 3: sql query alter table drop column

ALTER TABLE Customers
DROP COLUMN ContactName;