Thank this author by sharing:
This article explains you the differences between the Truncate and Delete commands in SQL.
Issue with truncation due to FOREIGN KEY constraint.
Can't Delete Index b/c of Constraint
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the...
Can't delete data until all constraints are dropped
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.