廣告：

ALTER TABLE [TakeStockDetail] WITH NOCHECK ADD CONSTRAINT [R/51] FOREIGN KEY([TakeStockID])
REFERENCES [TakeStock] ([TakeStockID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO

另外需要?jiǎng)h除所有外鍵關(guān)系

sql server 刪除庫里面所有表的外鍵關(guān)系

DECLARE @sql NVARCHAR(MAX) = '';
 
SELECT @sql = @sql + 'ALTER TABLE ' + QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.' + QUOTENAME(OBJECT_NAME(parent_object_id)) 
        + ' DROP CONSTRAINT ' + QUOTENAME(name) + ';'
FROM sys.foreign_keys
 WHERE schema_id = SCHEMA_ID('dbo'); -- 替換為你的數(shù)據(jù)庫模式名，例如 dbo
--WHERE schema_id = SCHEMA_ID('你的模式名'); -- 替換為你的數(shù)據(jù)庫模式名，例如 dbo
 
EXEC sp_executesql @sql;

廣告：