Alter Table Drop (SQL)

We can remove attributes (and data) by:

ALTER TABLE EMPLOYEE DROP JOB;

We can specify a foreign key to drop a constraint:

ALTER TABLE DEPARTMENT DROP FOREIGN KEY (MGRSSN);