Truncate a table that has foreign keys referencing its columns

Question

Truncate a table that has foreign keys referencing its columns

Jonathan AC Roberts

SSCoach

Points: 18407
More actions
April 3, 2017 at 1:18 pm

#401890

Comments posted to this topic are about the item Truncate a table that has foreign keys referencing its columns

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Dan Bragg Old Hand Points: 372 More actions · Answer 1

Great article, and I'll definitely be keeping this in my tool belt.
One really minor, nit-picky thing: In your list of examples, "1 -- debug only - no truncation" should be "0 -- debug only - no truncation". This is to prevent someone who quickly copies the two lines, then executes the first expecting a test but instead finds that they ran the truncation because they weren't paying attention.

Jonathan AC Roberts SSCoach Points: 18407 More actions · Answer 2

Dan Bragg - Tuesday, April 18, 2017 2:43 PM
One really minor, nit-picky thing: In your list of examples, "1 -- debug only - no truncation" should be "0 -- debug only - no truncation". This is to prevent someone who quickly copies the two lines, then executes the first expecting a test but instead finds that they ran the truncation because they weren't paying attention.

Thank you for the feedback.
I've amended the script and submitted it for republishing.

Truncate a table that has foreign keys referencing its columns

Cookies on SQLServerCentral