Altering multiple columns

• MrBaseball34

  SSCrazy

  Points: 2515

  More actions

  August 13, 2008 at 8:14 am

  #195829

  Is it possible to alter multiple columns in one call .vs doing this:

  ALTER TABLE dbo.coChargeCodes

  ALTER COLUMN Description nvarchar(255) NULL

  ALTER TABLE dbo.coChargeCodes

  ALTER COLUMN AlternateDescription nvarchar(255) NULL

  ALTER TABLE dbo.coChargeCodes

  ALTER COLUMN UB92Description nvarchar(255) NULL

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 13, 2008 at 8:18 am

  #857452

  Nope. You need an Alter Table for every Alter Column. It would be a nice feature to have though.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  August 13, 2008 at 8:26 am

  #857462

  can only be done for adding columns as far as i know

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉