I'm writing two scripts to upgrade a database to make it more robust (basically adding lots of constraints). The first script is the "validator" that you run first to see if you can upgrade or not. The second script does the Alter Table commands.
i.e. I need a way to check uniqueness of two columns before adding the unique constraint on them.
I think this is common, but I'm not googling the right terms guess.
Any help greatly appreciated, guys!
Dan