Alter / Change Column Data Type

• Joseph Mizrahi

  Valued Member

  Points: 72

  More actions

  March 30, 2005 at 7:46 am

  #166523

  Is there a way to alter a column's data type.... originally createda and data entered as "Varchar" and I want to make the field a Numeric type so that I can perform calculations....

   

  Thanks

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  March 30, 2005 at 8:57 am

  #549571

  Research ALTER TABLE in BOL or you can perform this via EM

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• archie0727

  SSC Enthusiast

  Points: 126

  More actions

  March 31, 2005 at 12:44 pm

  #549906

  Alter table tableA Alter Column ColA

  integer NULL

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  March 31, 2005 at 4:21 pm

  #549940

  I have found this works much better and quicker in Query Analyzer than using Enterprise Manager... 

  I wasn't born stupid - I had to study.