• One thing to worry about when you truncate tables with FKs is what if you can't rebuild the table where the keys you were using will match with the new keys generated? Assuming you're using an IDENTITY surrogate key. This is probably my biggest concern with trucating any production table with FKs. If you aren't sure they match, you have to regenerate all the keys in the child table's column with a big UPDATE.

    But still could be a good tool if you need to truncate some tables with FKs. Always good to see people building new tools! =)

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog