Hi all,

How to rename the user created database objects in SQL Server 2005?

The system procedure sp_rename is used to change the name of a user-created object in the current database. This object can be a table, index, column, alias data type, or Microsoft .NET Framework common language runtime (CLR) user-defined type.

SP_RENAME Syntax:
-------------------

sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name'
[ , [ @objtype = ] 'object_type' ]

To rename different database objects using SQL Server 2005
-------------------------------------------------------------

A. Renaming a table
----------------------
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';

B. Renaming a column
--------------------------
EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';


C. Renaming an index
----------------------------
EXEC sp_rename N'Purchasing.ProductVendor.IX_ProductVendor_Vendor ID', N'IX_VendorID', N'INDEX';


D. Renaming an alias data type
---------------------------------
EXEC sp_rename N'Phone', N'Telephone', N'USERDATATYPE';