/*
  Demonstrate that you need to remove constraints
  before deleting tables
*/
PROC SQL;
    ALTER TABLE EMP_TABLE
	DROP CONSTRAINT FOREIGN_EMP_DEPT_KEY;
    ALTER TABLE DEPT_TABLE
	DROP CONSTRAINT FOREIGN_DEPT_EMP_KEY;
    ALTER TABLE MGR_TABLE
	DROP CONSTRAINT FOREIGN_DEPT_KEY;
    ALTER TABLE MGR_TABLE
	DROP CONSTRAINT FOREIGN_EMP_KEY;
QUIT;

PROC SQL;
    DROP TABLE EMP_TABLE, DEPT_TABLE, MGR_TABLE, TEMP_EMPLOYEES;
QUIT;

PROC SQL;
    DROP TABLE TEMP_EMPLOYEES;
QUIT;