Getting Started with Adobe After Effects - Part 6:
First Time? You can support us by signing up. It takes only 5 seconds. Click
to sign up. If you already have an account, click here to
Submit a Tip
Did you learn something today?
what is this?
Clear data from a table with FOREIGN KEY
Nov 28 2011 5:11AM
I was trying to truncate a child table data and got the below error.
'Cannot truncate table <tablename> because it is being referenced by a FOREIGN KEY constraint'
From MSDN found that
"You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint; instead, use DELETE statement without a WHERE clause".
I knew this before.
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
Post this to my facebook wall
Send to my friends
Subscribe to RKA
Subscribe to Notifications
to post a comment.
Managed Windows Shared Hosting
Copyright © Rivera Informatic Private Ltd.