Drop a Column and All Corresponding Constraints

• Andy B.

  SSC Eights!

  Points: 890

  More actions

  September 27, 2007 at 2:42 pm

  #178162

  Comments posted to this topic are about the item Drop a Column and All Corresponding Constraints

  
  Enjoy!
  
  A Brown
  
  Manage all of your backups in one simple job using this script.

• 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.