Post reply

Truncate a table that has foreign keys referencing its columns

  • 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

  • April 18, 2017 at 2:43 pm

    #1938682

    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.

  • April 18, 2017 at 3:29 pm

    #1938687

    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 2 (of 2 total)

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