SQL Server 2016 中有外键的表无法被Truncate，只能被Delete

最新推荐文章于 2022-04-22 16:58:05 发布

anyi2404

最新推荐文章于 2022-04-22 16:58:05 发布

阅读量297

点赞数

原文链接：http://www.cnblogs.com/OpenCoder/p/9798545.html

版权

问：

I get the following message even when the table that references it is empty: "Cannot truncate table 'dbo.Link' because it is being referenced by a FOREIGN KEY constraint" Doesn't seem to make much sense why this is occurring. Any suggestions?

答

In SQL Server a table referenced by a FK cannot currently be truncated even if all referencing tables are empty or the foreign keys are disabled.
You need to use DELETE (may require much more logging) or drop the relationship(s) prior to using TRUNCATE and recreate them afterwards or see the workarounds on this connect item for a way of achieving this using ALTER TABLE ... SWITCH

原文链接

转载于:https://www.cnblogs.com/OpenCoder/p/9798545.html