Truncate a table that has foreign keys referencing its columns

  • Jonathan AC Roberts

    SSCoach

    Points: 16882

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

  • Dan Bragg

    Old Hand

    Points: 350

    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: 16882

    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.

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

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