Quote:
Originally posted by chrisrlong
Now mind you, I am all in favor of the database being as flexible as possible. Therfore, it pains me some to find myself on the other side of this argument. I am there mainly because *you should never do this*. This tells me that you are updating a PK and want the database to very nicely update a million rows in a dozen other tables for you. There is a fundamental problem there. IMHO, you should avoid meaninful keys at all costs...for this very reason. Use surrogate keys and your life will be much simpler and your database will thank you.
- Chris
I absolutely agree with Chris