DROP PROCEDURE PROC_NONE_PARAM;
DROP PROCEDURE PROC_SIMPLETYPE_PARAM;
DROP PROCEDURE PROC_SIMPLETYPE_TIME_PARAM;
DROP PROCEDURE PROC_DTO_PARAM;
DROP PROCEDURE PROC_DTO_TIME_PARAM;
DROP PROCEDURE PROC_RESULTSET;
DROP PROCEDURE PROC_RESULTSET_OUT;
DROP PROCEDURE PROC_RESULTSET_UPDATE;
DROP PROCEDURE PROC_RESULTSET_UPDATE2;
DROP PROCEDURE PROC_RESULTSETS;
DROP PROCEDURE PROC_RESULTSETS_UPDATES_OUT;

DROP FUNCTION FUNC_NONE_PARAM;
DROP FUNCTION FUNC_SIMPLETYPE_PARAM;
DROP FUNCTION FUNC_SIMPLETYPE_TIME_PARAM;
DROP FUNCTION FUNC_DTO_PARAM;
DROP FUNCTION FUNC_DTO_TIME_PARAM;
DROP FUNCTION FUNC_RESULTSET;
DROP FUNCTION FUNC_RESULTSET_UPDATE2;

DROP TABLE EMPLOYEE;
DROP TABLE ADDRESS;
DROP TABLE DEPARTMENT;

DROP TABLE COMP_KEY_EMPLOYEE;
DROP TABLE COMP_KEY_ADDRESS;
DROP TABLE COMP_KEY_DEPARTMENT;

DROP TABLE CONSTRAINT_CHECKING;
DROP TABLE LARGE_OBJECT;
DROP TABLE TENSE;
DROP TABLE JOB;
DROP TABLE AUTHORITY;
DROP TABLE NO_ID;
DROP TABLE OWNER_OF_NO_ID;

DROP TABLE ID_GENERATOR;
DROP TABLE MY_ID_GENERATOR;
DROP TABLE AUTO_STRATEGY;
DROP TABLE IDENTITY_STRATEGY;
DROP TABLE SEQUENCE_STRATEGY;
DROP TABLE SEQUENCE_STRATEGY2;
DROP TABLE TABLE_STRATEGY;
DROP TABLE TABLE_STRATEGY2;
DROP TABLE PATTERN;

DROP SEQUENCE AUTO_STRATEGY_ID;
DROP SEQUENCE SEQUENCE_STRATEGY_ID;
DROP SEQUENCE MY_SEQUENCE_STRATEGY_ID;