学步园

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[FK_table1_table2]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
    ALTER TABLE dbo.table1 DROP CONSTRAINT FK_table1_table2