Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Truncate Table
Message
From
02/03/2001 16:27:13
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Truncate Table
Miscellaneous
Thread ID:
00481552
Message ID:
00481552
Views:
49
When I try to truncate a table I get the following error message:

Server: Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'RoutePoint_tbl' because it is being referenced by a FOREIGN KEY constraint.

I have deleted all the rows from any of this table's child tables, so I have no idea why I should get this error. I do not delete any rows from the specified tables parent tables because I don't believe this should be needed. I don't know why I am getting this error.
Next
Reply
Map
View

Click here to load this message in the networking platform