analytics/configuration/schemas/delivery/sqlserver/NC_DROP_MS.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_MS.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_MS.sql        *  DO NOT EDIT  *
-------------------------------------------------------------------------------