Cannot truncate table ‘xyz’ because it is being referenced by a FOREIGN KEY constraint – Sql Server

In this article we will discuss on when we get the error like below in Sql Server and how to resolve it. Msg 4712, Level 16, State 1, Line 1 Cannot truncate table ‘Customer’ because it is being referenced by a FOREIGN KEY constraint. To demonstrate this error let us first create a demo db … Continue reading Cannot truncate table ‘xyz’ because it is being referenced by a FOREIGN KEY constraint – Sql Server