Forum Discussion
Issue Truncating Table with Foreign Key Constraints in Microsoft SQL Server 2022
Hi everyone, I'm currently working with Microsoft SQL Server 2022, and I'm encountering an issue when trying to truncate a table. The error message I'm receiving is as follows: "Cannot truncate ...
What's the point in having the functionality if you can't use it as its intended
A TRUNCATE TABLE is not intended to break foreign key relations; it works as it should do and this mean respecting PK/FK relations.