I agree that No is the answer to your question, however I wanted to see if anyone could give me a clue as to why a
Delete tablename
works and a
Truncate tablename
does not. It give me the error that a FK error exists, but gives no ref to the FK and I was unable to find one. Using the Delete command gave me the desired results -- but with a great deal of extra logging -- table had ~ 3million records.
Thanks for any help in understanding.
-- NO