Assume that table
Dept is being referenced by a FOREIGN KEY in Employee table.
If you are trying to truncate the
Dept table's data,
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....