DROP FUNCTION PROC_NONE_PARAM();
DROP FUNCTION PROC_SIMPLETYPE_PARAM(param1 integer);
DROP FUNCTION PROC_SIMPLETYPE_TIME_PARAM(param1 time);
DROP FUNCTION PROC_DTO_PARAM(IN param1 integer, INOUT param2 integer, OUT param3 integer);
DROP FUNCTION PROC_DTO_TIME_PARAM(IN param1 time, INOUT param2 time, OUT param3 time);
DROP FUNCTION PROC_RESULTSET(OUT cur refcursor, IN employeeid integer);
DROP FUNCTION PROC_RESULTSET_OUT(cur OUT refcursor, employeeId IN INTEGER, employeeCount OUT INTEGER);
DROP FUNCTION PROC_RESULTSET_UPDATE(cur OUT refcursor, employeeId IN INTEGER);
DROP FUNCTION PROC_RESULTSET_UPDATE2(cur OUT refcursor, employeeId IN INTEGER);
DROP FUNCTION PROC_RESULTSETS(OUT empcur refcursor, OUT deptcur refcursor, IN employeeid integer, IN departmentid integer);
DROP FUNCTION PROC_RESULTSETS_UPDATES_OUT(empCur OUT refcursor, deptCur OUT refcursor, employeeId IN INTEGER, departmentId IN INTEGER, employeeCount OUT INTEGER);

DROP FUNCTION FUNC_NONE_PARAM();
DROP FUNCTION FUNC_SIMPLETYPE_PARAM(param1 IN INTEGER);
DROP FUNCTION FUNC_SIMPLETYPE_TIME_PARAM(param1 IN TIME);
DROP FUNCTION FUNC_DTO_PARAM(param1 IN INTEGER, param2 IN INTEGER);
DROP FUNCTION FUNC_DTO_TIME_PARAM(param1 IN TIME, param2 IN INTEGER);
DROP FUNCTION FUNC_RESULTSET(employeeId IN INTEGER);
DROP FUNCTION FUNC_RESULTSET_UPDATE(employeeId IN INTEGER);
DROP FUNCTION FUNC_RESULTSET_UPDATE2(employeeId IN INTEGER);

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 PATTERN;

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 SEQUENCE SEQUENCE_STRATEGY_ID;
DROP SEQUENCE MY_SEQUENCE_STRATEGY_ID;