使用外键删除表 [英] Drop table with foreign key

问题描述

我正在尝试这个代码

Drop Table Inventory

出现错误:

无法删除对象库存"，因为它被一个引用外键约束.

Could not drop object 'Inventory' because it is referenced by a FOREIGN KEY constraint.

推荐答案

首先你必须Drop 表格的约束，然后表格

First you have to Drop the table's constraints and then table

SELECT 
    'ALTER TABLE ' +  OBJECT_SCHEMA_NAME(parent_object_id) +
    '.[' + OBJECT_NAME(parent_object_id) + 
    '] DROP CONSTRAINT ' + name
FROM sys.foreign_keys
WHERE referenced_object_id = object_id('Inventory')
Drop Table Inventory

这篇关于使用外键删除表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！