Assume that table Dept
is being referenced by a FOREIGN KEY in Employee table.
If you are trying to truncate the Dept
TRUNCATE TABLE TableName1
gives the error Cannot truncate table 'dept' because it is being referenced by a FOREIGN KEY constraint Solution:
In this case, we have to use DELETE statement to delete the records....