Home Forums Article Discussions Article Discussions by Author Discuss content posted by Andy Brown Drop a Column and All Corresponding Constraints RE: Drop a Column and All Corresponding Constraints
Lau-765114
Old Hand
Points: 345
More actions
May 30, 2008 at 10:49 am
#822456
Just wonderful ! Thanks a lot !
Oh, just one suggestion: if, let's say, column not found, then cursor is not deallocated and script fails next time you try to run it. I would probably take "DEALLOCATE cur_constraints" out of IF/ELSE block.