Alter Table

• pradeep24

  Newbie

  Points: 9

  More actions

  July 2, 2002 at 2:13 am

  #78633

  How to Insert a column at a particular position in a table?

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  July 2, 2002 at 3:36 am

  #431950

  Hi, you can do that with enterprise manager. If you want to do this with qa then you have to drop and recreate the table.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  July 2, 2002 at 10:02 am

  #431986

  EM will drop and create the table for you. Check the script if you want to learn how this works.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones