How to Drop Unused Empty Redundant columns

• kodracon

  Ten Centuries

  Points: 1027

  More actions

  October 25, 2008 at 2:23 am

  #192534

  Comments posted to this topic are about the item How to Drop Unused Empty Redundant columns

• Tim Wilson-Brown

  Ten Centuries

  Points: 1395

  More actions

  February 5, 2009 at 6:40 pm

  #939282

  This could be a very risky script for people to use for two reasons:

  * Column Names are typed SYSNAME, which is NVARCAHR(128) , not VARCAHR(30)

  * You use dynamic SQL without QUOTENAME(), which means your script could fail on column names that are not regular identifiers.