Rename Column

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  November 23, 2012 at 9:32 am

  #270683

  I have a column name with name 'Procedure.ID' and want to rename it as 'ProcedureID'

  i write as:

  sp_rename ''Procedure.Procedure.ID','ProcedureID'

  but its not wrking...

  plz reply

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  November 23, 2012 at 9:40 am

  #1561894

  sp_rename 'tablename.[columnname],'column_name'

  it will works 🙂

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/