HOW TO ALTER /RENAME TABLE NAME WITH TSQL CODE?

• invaliddba

  Default port

  Points: 1450

  More actions

  May 20, 2011 at 7:11 am

  #236587

  HOW DO I CHANGE THE TABLE NAME WITH TSQL CODE?

  THANKS

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 20, 2011 at 7:14 am

  #1327661

  sp_rename

• jarid.lawson

  SSCrazy

  Points: 2953

  More actions

  May 20, 2011 at 11:09 am

  #1327838

  To rename a table

  Exec sp_Rename 'schema.original_table_name','new_table_name','object'

  Go

  To rename a field

  Exec sp_Rename 'schema.table_name.original_field_name','new_field_name','column'

  Go

  Note: The rule requiring [brackets] around partially invalid names (i.e. - dbo.[1_Table_Name]) should be used in the original name section of the statement, but DO NOT use it in the new name section of the statement.

  Example:

  Exec sp_Rename 'dbo.[1_table_name].[2_original_field_name]','3_new_field_name','column'

  [font="Arial"]“Any fool can know. The point is to understand.”
  - Albert Einstein

  "DOH!"
  - Homer Simpson[/font]