Clear data from a table with FOREIGN KEY

Getting Started with Adobe After Effects - Part 6: Motion Blur

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Just Learned...


	Submit a Tip

Subscribe to
Follow @just_learned

RKA

91 · 2% · 598

Learned it

Liked it

Knew it

Did you learn something today? Share It!

Unread · Most Liked · Most Learned · Most Discussed · Upcoming

Silver Rated new | what is this?

Clear data from a table with FOREIGN KEY

Nov 28 2011 5:11AM by RKA Edit

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".
Read More...

SQL Server

Liked

Learned

Knew

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
Tweet this

Like this


	Submit


	Send to my friends


	Subscribe to RKA

	Subscribe to Notifications
Your Comment

Sign Up or Login to post a comment.

Managed Windows Shared Hosting by OrcsWeb

Just Learned...

Learned it

Liked it

Knew it

Did you learn something today? Share It!

Clear data from a table with FOREIGN KEY

SQL Server

Your Comment