if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_帐单明细_入住单]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[帐单明细] DROP CONSTRAINT FK_帐单明细_入住单
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_入住单_客房信息]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[入住单] DROP CONSTRAINT FK_入住单_客房信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_客房信息_客房类型]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[客房信息] DROP CONSTRAINT FK_客房信息_客房类型
