Code Snippet posted by:
CGN007 | Posted on: 6/29/2012 | Category:
SQL Server Codes | Views: 1121 | Status:
[Member] |
Points: 40
|
Alert Moderator
Renaming table/column using sp_rename in SQL SERVER 2008
sp_rename
sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name'
[ , [ @objtype = ] 'object_type' ]
Simple syntax
Renaming any column :
sp_RENAME 'Table_Name.[Old_Column_Name]' , '[New_Column_Name]', 'COLUMN'
Renaming any object (table, sp etc) :
sp_RENAME '[Old_Table_Name]' , '[New_Table_Name]'
Example
sp_rename 'employee.name','fullname','COLUMN"
sp_rename 'employee','employeedetails'