analytics/configuration/schemas/delivery/hsql/NC_DROP_Hsql.sql

--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: JSM
--    
--    (c) Copyright IBM Corp. 2003, 2015
--    
--    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
--    


-------------------------------------------------------------------------------
-- NC_DROP_HSQL.sql         *  DO NOT EDIT  *          Data Store Version: 1032
-------------------------------------------------------------------------------

ALTER TABLE NC_JOBQUEUE
   DROP CONSTRAINT PN_JOBQUEUE;

ALTER TABLE NC_MESSAGELINE
   DROP CONSTRAINT F1N_MESSAGELINE;

ALTER TABLE NC_MESSAGELINE_ELEMENT
   DROP CONSTRAINT F1N_MESSAGELINE_EL;

ALTER TABLE R_MESSAGESTRUCT_TASK
   DROP CONSTRAINT F2R_MESSAGESTRUCT_;

ALTER TABLE R_MESSAGESTRUCT_TASK
   DROP CONSTRAINT F1R_MESSAGESTRUCT_;
   
ALTER TABLE NC_METRICS
   DROP CONSTRAINT PN_METRICS;

ALTER TABLE R_MSGSTRUCT_RECIPIENT_DELIVINF
   DROP CONSTRAINT F3R_MSGSTRUCT_RECI;

ALTER TABLE R_MSGSTRUCT_RECIPIENT_DELIVINF
   DROP CONSTRAINT F1R_MSGSTRUCT_RECI;

ALTER TABLE NC_SDS_INSTANCE
   DROP CONSTRAINT PN_SDS_INSTANCE;

ALTER TABLE NC_TASKSCHEDULE
   DROP CONSTRAINT F1N_TASKSCHEDULE;

ALTER TABLE R_TASKSCHEDULE_SCHEDULE
   DROP CONSTRAINT F2R_TASKSCHEDULE_S;

ALTER TABLE R_TASKSCHEDULE_SCHEDULE
   DROP CONSTRAINT F1R_TASKSCHEDULE_S;

DROP TABLE NC_CONFIGURATION;

DROP TABLE NC_CTMAP;

DROP TABLE NC_DB_VERSION;

DROP TABLE NC_DELIVERYADDRESS;

DROP TABLE NC_EVENTSTATUS;

DROP TABLE NC_JMSQUEUE;

DROP TABLE NC_JOBQUEUE;

DROP TABLE NC_MESSAGELINE;

DROP TABLE NC_MESSAGELINE_ELEMENT;

DROP TABLE NC_MESSAGESTRUCT;

DROP TABLE NC_METRICS;

DROP TABLE NC_OBJECTCATALOGUE;

DROP TABLE NC_OBJECTID;

DROP TABLE NC_PERMISSION;

DROP TABLE NC_RECIPIENT;

DROP TABLE NC_SCHEDULE;

DROP TABLE NC_SCHEDULE_QUEUE;

DROP TABLE NC_SDS_INSTANCE;

DROP TABLE NC_TASK;

DROP TABLE NC_TASKSCHEDULE;

DROP TABLE NC_SCHEDULED_EVENT_OVERRIDE;

DROP TABLE NC_TASK_HISTORY_DETAIL;

DROP TABLE NC_TASK_HISTORY_SUB_INDEX;

DROP TABLE NC_TASK_PROPERTY;

DROP TABLE NC_TASK_QUEUE;

DROP TABLE NC_TSE_STATE_MAP;

DROP TABLE NC_TASK_ANCESTOR_STOREIDS;

DROP TABLE R_MESSAGESTRUCT_TASK;

DROP TABLE R_MSGSTRUCT_RECIPIENT_DELIVINF;

DROP TABLE R_NEWSITEMS_NCOBJECTS;

DROP TABLE R_TASKSCHEDULE_SCHEDULE;

DROP TABLE NC_RESOURCE_LOCK;

-------------------------------------------------------------------------------
--	END NC_DROP_HSQL.sql        *  DO NOT EDIT  *
-------------------------------------------------------------------------------