if exists (select 1
from sysindexes
where id = object_id('Relationship_5') and name = 'Relationship_5_FK' and indid > 0 and indid < 255)
drop index Relationship_5.Relationship_5_FK go
if exists (select 1
from sysindexes
where id = object_id('Relationship_5') and name = 'Relationship_6_FK' and indid > 0 and indid < 255)
drop index Relationship_5.Relationship_6_FK go
if exists (select 1
from sysindexes
where id = object_id('Relationship_6') and name = 'Relationship_7_FK' and indid > 0 and indid < 255)
drop index Relationship_6.Relationship_7_FK go
if exists (select 1
from sysindexes
where id = object_id('Relationship_6') and name = 'Relationship_8_FK' and indid > 0 and indid < 255)
drop index Relationship_6.Relationship_8_FK go
if exists (select 1
from sysindexes
where id = object_id('Relationship_7') and name = 'Relationship_10_FK' and indid > 0 and indid < 255)
drop index Relationship_7.Relationship_10_FK
go
if exists (select 1
from sysindexes
where id = object_id('Relationship_7') and name = 'Relationship_9_FK' and indid > 0 and indid < 255)
drop index Relationship_7.Relationship_9_FK go
if exists (select 1
from sysindexes
where id = object_id('Relationship_8') and name = 'Relationship_11_FK' and indid > 0 and indid < 255)
drop index Relationship_8.Relationship_11_FK go
if exists (select 1
from sysindexes
where id = object_id('Relationship_8') and name = 'Relationship_12_FK' and indid > 0 and indid < 255)
drop index Relationship_8.Relationship_12_FK go
if exists (select 1
from sysindexes
where id = object_id('供货表') and name = 'Relationship_13_FK' and indid > 0 and indid < 255)
drop index 供货表.Relationship_13_FK go
if exists (select 1
from sysindexes
where id = object_id('供货表') and name = 'Relationship_16_FK' and indid > 0 and indid < 255)
drop index 供货表.Relationship_16_FK go
if exists (select 1
from sysindexes
where id = object_id('客户')
and name = 'Relationship_20_FK' and indid > 0 and indid < 255)
drop index 客户.Relationship_20_FK go
if exists (select 1
from sysindexes
where id = object_id('客户')
and name = 'Relationship_21_FK' and indid > 0 and indid < 255)
drop index 客户.Relationship_21_FK go
if exists (select 1
from sysindexes
where id = object_id('库存表') and name = 'Relationship_14_FK' and indid > 0 and indid < 255)
drop index 库存表.Relationship_14_FK go
if exists (select 1
from sysindexes
where id = object_id('统计报表') and name = 'Relationship_4_FK' and indid > 0 and indid < 255)
drop index 统计报表.Relationship_4_FK go
if exists (select 1
from sysindexes
where id = object_id('订单表') and name = 'Relationship_1_FK' and indid > 0
and indid < 255)
drop index 订单表.Relationship_1_FK go
if exists (select 1
from sysindexes
where id = object_id('订单表') and name = 'Relationship_2_FK' and indid > 0 and indid < 255)
drop index 订单表.Relationship_2_FK go
if exists (select 1
from sysindexes
where id = object_id('订单表') and name = 'Relationship_3_FK' and indid > 0 and indid < 255)
drop index 订单表.Relationship_3_FK go
if exists (select 1
from sysindexes
where id = object_id('财务结算表') and name = 'Relationship_17_FK' and indid > 0 and indid < 255)
drop index 财务结算表.Relationship_17_FK go
if exists (select 1
from sysindexes
where id = object_id('采购表') and name = 'Relationship_15_FK' and indid > 0 and indid < 255)
drop index 采购表.Relationship_15_FK go
if exists (select 1
from sysindexes
where id = object_id('销售部门') and name = 'Relationship_18_FK'
and indid > 0 and indid < 255)
drop index 销售部门.Relationship_18_FK go
if exists (select 1
from sysindexes
where id = object_id('销售部门') and name = 'Relationship_19_FK' and indid > 0 and indid < 255)
drop index 销售部门.Relationship_19_FK go
if exists (select 1
from sysobjects
where id = object_id('Relationship_18') and type = 'U') drop table Relationship_18 go
if exists (select 1
from sysobjects
where id = object_id('Relationship_19') and type = 'U') drop table Relationship_19 go
if exists (select 1
from sysobjects
where id = object_id('Relationship_5') and type = 'U') drop table Relationship_5 go
if exists (select 1
from sysobjects
where id = object_id('Relationship_6') and type = 'U') drop table Relationship_6 go
if exists (select 1
from sysobjects
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库物流配送系统数据库设计(SQL)(5)在线全文阅读。
相关推荐：