--
--    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_SYBASE.sql         *  DO NOT EDIT  *         Data Store Version: 1032
-------------------------------------------------------------------------------

ALTER TABLE NC_JOBQUEUE
   DROP CONSTRAINT PN_JOBQUEUE
go

ALTER TABLE NC_MESSAGELINE
   DROP CONSTRAINT F1N_MESSAGELINE
go

ALTER TABLE NC_MESSAGELINE_ELEMENT
   DROP CONSTRAINT F1N_MESSAGELINE_EL
go

ALTER TABLE NC_METRICS
   DROP CONSTRAINT PN_METRICS
go

ALTER TABLE R_MESSAGESTRUCT_TASK
   DROP CONSTRAINT F2R_MESSAGESTRUCT_
go

ALTER TABLE R_MESSAGESTRUCT_TASK
   DROP CONSTRAINT F1R_MESSAGESTRUCT_
go

ALTER TABLE R_MSGSTRUCT_RECIPIENT_DELIVINF
   DROP CONSTRAINT F3R_MSGSTRUCT_RECI
go

ALTER TABLE R_MSGSTRUCT_RECIPIENT_DELIVINF
   DROP CONSTRAINT F1R_MSGSTRUCT_RECI
go

ALTER TABLE NC_SDS_INSTANCE
   DROP CONSTRAINT PN_SDS_INSTANCE
go

ALTER TABLE NC_TASKSCHEDULE
   DROP CONSTRAINT F1N_TASKSCHEDULE
go

ALTER TABLE R_TASKSCHEDULE_SCHEDULE
   DROP CONSTRAINT F2R_TASKSCHEDULE_S
go

ALTER TABLE R_TASKSCHEDULE_SCHEDULE
   DROP CONSTRAINT F1R_TASKSCHEDULE_S
go

DROP TABLE NC_CONFIGURATION
go

DROP TABLE NC_CTMAP
go

DROP TABLE NC_DB_VERSION
go

DROP TABLE NC_DELIVERYADDRESS
go

DROP TABLE NC_EVENTSTATUS
go

DROP TABLE NC_JMSQUEUE
go

DROP TABLE NC_JOBQUEUE
go

DROP TABLE NC_MESSAGELINE
go

DROP TABLE NC_MESSAGELINE_ELEMENT
go

DROP TABLE NC_MESSAGESTRUCT
go

DROP TABLE NC_METRICS
go

DROP TABLE NC_OBJECTCATALOGUE
go

DROP TABLE NC_OBJECTID
go

DROP TABLE NC_PERMISSION
go

DROP TABLE NC_RECIPIENT
go

DROP TABLE NC_SCHEDULE
go

DROP TABLE NC_SCHEDULE_QUEUE
go

DROP TABLE NC_SDS_INSTANCE
go

DROP TABLE NC_TASK
go

DROP TABLE NC_TASKSCHEDULE
go

DROP TABLE NC_TASK_HISTORY_DETAIL
go

DROP TABLE NC_TASK_HISTORY_SUB_INDEX
go

DROP TABLE NC_TASK_PROPERTY
go

DROP TABLE NC_TASK_QUEUE
go

DROP TABLE NC_TSE_STATE_MAP
go

DROP TABLE NC_TASK_ANCESTOR_STOREIDS
go

DROP TABLE R_MESSAGESTRUCT_TASK
go

DROP TABLE R_MSGSTRUCT_RECIPIENT_DELIVINF
go

DROP TABLE R_NEWSITEMS_NCOBJECTS
go

DROP TABLE R_TASKSCHEDULE_SCHEDULE
go

DROP TABLE NC_SCHEDULED_EVENT_OVERRIDE
go

DROP TABLE NC_RESOURCE_LOCK
go

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