-------删除房间相关外键-------
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_接待外键房间]') AND parent_object_id = OBJECT_ID(N'T_RECEIVE'))
  ALTER TABLE T_RECEIVE drop CONSTRAINT FK_接待外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_外键房间]') AND parent_object_id = OBJECT_ID(N'T_DESTINE'))
  ALTER TABLE T_DESTINE drop CONSTRAINT FK_外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_房间呼叫房间外键]') AND parent_object_id = OBJECT_ID(N'T_ROOMCALL'))
  ALTER TABLE T_ROOMCALL drop CONSTRAINT FK_房间呼叫房间外键;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_清扫外键房号]') AND parent_object_id = OBJECT_ID(N'T_DEPURATE'))
  ALTER TABLE T_DEPURATE drop CONSTRAINT FK_清扫外键房号;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_智能提醒外键房间]') AND parent_object_id = OBJECT_ID(N'T_REMINDBILL'))
  ALTER TABLE T_REMINDBILL drop CONSTRAINT FK_智能提醒外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_提醒处理记录外键房间]') AND parent_object_id = OBJECT_ID(N'T_REMINDNOTES'))
  ALTER TABLE T_REMINDNOTES drop CONSTRAINT FK_提醒处理记录外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_技师加钟提醒外键房间]') AND parent_object_id = OBJECT_ID(N'T_NAMEDAWAKE'))
  ALTER TABLE T_NAMEDAWAKE drop CONSTRAINT FK_技师加钟提醒外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员统计项目外键房间]') AND parent_object_id = OBJECT_ID(N'T_CLIENTUSEDSTATGOODS'))
  ALTER TABLE T_CLIENTUSEDSTATGOODS drop CONSTRAINT FK_会员统计项目外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_检查记录外键房间编号]') AND parent_object_id = OBJECT_ID(N'T_ROOMCHECKLOG'))
  ALTER TABLE T_ROOMCHECKLOG drop CONSTRAINT FK_检查记录外键房间编号;
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_呼叫铃映射外键房间]') AND parent_object_id = OBJECT_ID(N'T_XUNLING'))
  ALTER TABLE T_XUNLING drop CONSTRAINT FK_呼叫铃映射外键房间;
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_设备房间外键]') AND parent_object_id = OBJECT_ID(N'T_SMARTLIST'))
  ALTER TABLE T_SMARTLIST drop CONSTRAINT FK_设备房间外键;
GO