ALTER DROP
Delete column
ALTER TABLE table_name
DROP COLUMN column_name;
Primary Key / Foreign Key
constraints
Delete ALTER TABLE lab_location
DROP PRIMARY KEY;
or
ALTER TABLE lab_location
DROP FOREIGN KEY 'lam_emp_fk';
UNIQUE
constraints
Delete Unique constraints cannot be removed without the name of the constraints.
ALTER TABLE lab_loction
DROP INDEX loc_name_un;