SQL DROP COLUMN

The following command will drop middle_name from the tenants table.

-- Works for PostgreSQL, MySQL, SQL Server, and Oracle ALTER TABLE tenants DROP COLUMN middle_name;