Monday, May 09, 2005

Rename user-created objects in SQL Server

Rename user-created object (for example, table, column, or user-defined data type) in the present database:

Syntax:
sp_rename oldName, newName, [Object]

Rename Table
sp_rename 'Employee', 'Employees'
or
sp_rename 'Employee', 'Employees', 'TABLE'


Rename Column
sp_rename 'EName', '[Emp Name]', 'COLUMN'

posted by Chandra Ananthapatnayakuni @ 5/09/2005 09:43:00 PM

1 Comments:

At 10:27 PM, Blogger Sivakumar said...

Hi Chandra,
The workable syntax for renaming a column is like following

sp_rename 'Employees.[EName]', 'Emp Name', 'COLUMN'

 

Post a Comment

<< Home