Posted by Jens on 12/16/05 09:46
Like said in the BOL:
"You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY
constraint; instead, use DELETE statement without a WHERE clause."
Therefore the only way is to delete the FK and do the truncate and
recreate the FK, or to use an insert statement instead.
HTH, jens Suessmeyer.
[Back to original message]
|