We help IT Professionals succeed at work.

Sql Server - Can not truncate Table

JElster
JElster asked
on
Hi..
I'm getting the following
Cannot truncate table 'myTable' because it is being referenced by a FOREIGN KEY constraint.

How can find the FOREIGN KEY constraint and remove it - and find the other 'tables'

thx
Comment
Watch Question

If you have management studio you can look under TableName--Keys to see all foreign keys of the table.

You need to be careful you don't destroy data in the referenced tables.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.