mplusDemo/mplus-fatima/script/oracle/drop_Oracle_Table_For_MPlus.sql

-- Hospital Table Drop
DROP TABLE MP_API_PARAM; 
DROP TABLE MP_API_HEADER; 
DROP TABLE MP_API; 
DROP TABLE MP_API_CATEGORY; 
DROP TABLE MP_I18N; 
DROP TABLE MP_MANAGER; 
DROP TABLE MP_TELNO; 
DROP TABLE MP_AGREEMENT;
DROP TABLE MP_USER_AGREEMENT;
DROP TABLE MP_PUSH_FORM; 
DROP TABLE MP_MENU_PARAM;
DROP TABLE MP_MENU_AUTH;
DROP TABLE MP_MENU; 


-- Common Table Drop
DROP TABLE MP_VERSION; 
DROP TABLE MNS_RECEIVER_DEVICE; 
DROP TABLE MNS_RECEIVER_RESULT; 
DROP TABLE MNS_RECEIVER; 
DROP TABLE MNS_CONTENTS_RESULT; 
DROP TABLE MNS_CONTENTS; 
DROP TABLE MP_MNS_MSGMAPPING;
DROP TABLE MP_ATTR;
DROP TABLE MP_USER_ATTR; 
DROP TABLE MP_EXTRA_ATTR_USER; 
DROP TABLE MP_EXTRA_ATTR; 
DROP TABLE MP_AUTH_ATTR;
DROP TABLE MP_AUTH; 
DROP TABLE MP_USER_DEVICE;
DROP TABLE MP_PUBLIC_DEVICE;
DROP TABLE MP_USER;

DROP SEQUENCE SEQ_MP_API_AS; 
DROP SEQUENCE SEQ_MP_API_CATEGORY_CS; 
DROP SEQUENCE SEQ_MP_API_HEADER_HS; 
DROP SEQUENCE SEQ_MP_API_PARAM_PS; 
DROP SEQUENCE SEQ_MP_TELNO_TS; 
DROP SEQUENCE SEQ_MP_MENU_PARAM_SEQ_MPS; 
DROP SEQUENCE SEQ_MP_MENU_AUTH;

DROP SEQUENCE SEQ_MNS_CONTENTS; 
DROP SEQUENCE SEQ_MP_ATTR;
DROP SEQUENCE SEQ_MP_USER_ATTR; 
DROP SEQUENCE SEQ_MP_EXTRA_ATTR; 
DROP SEQUENCE SEQ_MP_EXTRA_ATTR_USER; 
DROP SEQUENCE SEQ_MP_AUTH_ATTR;
DROP SEQUENCE SEQ_MP_AUTH;
DROP SEQUENCE SEQ_MP_USER_DEVICE;
DROP SEQUENCE SEQ_MP_PUBLIC_DEVICE;
DROP SEQUENCE SEQ_MP_USER_US;
COMMIT;