SQLServerCentral / Discuss content posted by Andy Brown / Article Discussions / Article Discussions by Author / Drop a Column and All Corresponding Constraints / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 12:31:45 GMT20RE: Drop a Column and All Corresponding Constraintshttp://www.sqlservercentral.com/Forums/Topic403763-422-1.aspxJust 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.Fri, 30 May 2008 10:49:29 GMTLau-765114Drop a Column and All Corresponding Constraintshttp://www.sqlservercentral.com/Forums/Topic403763-422-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31737/">Drop a Column and All Corresponding Constraints</A>[/B]Thu, 27 Sep 2007 14:42:39 GMTAndy B.