column name change

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  January 18, 2008 at 1:57 pm

  #182206

  i have copied data from columnA to other columnB in a table.

  I want to rename ColumnA as something else and rename ColumnB to ColumnA

  How do i do it?

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  January 18, 2008 at 2:23 pm

  #769891

  sql server management studio makes it easy. just open the table, its columns, and right-click the column (or click it twice).

  from the command line, use sp_rename

  EXEC sp_rename

  @objname = 'table_name.old_column_name',

  @newname = 'new_column_name',

  @objtype = 'COLUMN'