Anyone have a foolprof DropColumn stored procedure?

• John F

  SSCommitted

  Points: 1597

  More actions

  February 14, 2005 at 1:58 pm

  #60696

  Constraints need to be dropped, statistics need to be dropped, etc. before dropping a column.  Does anyone have a good DropColumn stored procedure that just takes table and column name?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 15, 2005 at 1:56 am

  #542212

  I bet you'll find something useful here in the script section.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• John F

  SSCommitted

  Points: 1597

  More actions

  February 15, 2005 at 11:32 am

  #542357

  Thanks.  I ended up writing my own and added it to the end of this post here. 

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=161298

  There was another good solution in there too.

   

  - John