/*==============================================================*/
/* DBMS name: Microsoft SQL Server 2005 */
/* Created on: 2010/9/16 0:40:17 */
/*==============================================================*/
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('DepartmentInfo') and o.name = 'FK_DEPARTME_REFERENCE_TEACHERI')
alter table DepartmentInfo
drop constraint FK_DEPARTME_REFERENCE_TEACHERI
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('DeviceSubSubType') and o.name = 'FK_DEVICESU_REFERENCE_DEVICESU')
alter table DeviceSubSubType
drop constraint FK_DEVICESU_REFERENCE_DEVICESU
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('DeviceSubType') and o.name = 'FK_DEVICESU_REFERENCE_DEVICETY')
alter table DeviceSubType
drop constraint FK_DEVICESU_REFERENCE_DEVICETY
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApplyDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEPARTME3')
alter table EquipmentApplyDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEPARTME3
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApplyDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI8')
alter table EquipmentApplyDetail
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI8
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApplyDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICETY3')
alter table EquipmentApplyDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEVICETY3
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApplyDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICESU5')
alter table EquipmentApplyDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEVICESU5
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApplyDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICESU6')
alter table EquipmentApplyDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEVICESU6
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApproveDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_EQUIPMEN2')
alter table EquipmentApproveDetail
drop constraint FK_EQUIPMEN_REFERENCE_EQUIPMEN2
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApproveDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEPARTME4')
alter table EquipmentApproveDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEPARTME4
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApproveDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI9')
alter table EquipmentApproveDetail
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI9
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApproveDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICETY4')
alter table EquipmentApproveDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEVICETY4
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApproveDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICESU7')
alter table EquipmentApproveDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEVICESU7
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentApproveDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICESU8')
alter table EquipmentApproveDetail
drop constraint FK_EQUIPMEN_REFERENCE_DEVICESU8
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_EQUIPMEN1')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_EQUIPMEN1
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICETY2')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_DEVICETY2
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICESU3')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_DEVICESU3
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_DEVICESU4')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_DEVICESU4
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI7')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI7
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_DEPARTME2')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_DEPARTME2
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInfo') and o.name = 'FK_EQUIPMEN_REFERENCE_STORAGEI2')
alter table EquipmentInfo
drop constraint FK_EQUIPMEN_REFERENCE_STORAGEI2
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInputStorageListDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI3')
alter table EquipmentInputStorageListDetail
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI3
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInputStorageListDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI4')
alter table EquipmentInputStorageListDetail
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI4
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInputStorageListDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI5')
alter table EquipmentInputStorageListDetail
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI5
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('EquipmentInputStorageListDetail') and o.name = 'FK_EQUIPMEN_REFERENCE_TEACHERI6')
alter table EquipmentInputStorageListDetail
drop constraint FK_EQUIPMEN_REFERENCE_TEACHERI6
go
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.typ
评论0
最新资源