Truncate tables where Referential Integrity exists

Question

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

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

seebert42 SSC Enthusiast Points: 136 More actions · Answer 1

This seems like a very dangerous thing to do from a data governance standpoint. Won't you leave abandoned keys in related tables this way?

Ted Seeber
I find your secrets in your data.
http://www.informaitonr.us

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

the code creates the drop commands and the create commands, it's for dev use so test it first to ensure it does what you require

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉