This is a discussion on To rename user created objects in sql server 2005 within the Database Support forums, part of the Web Development category; Hi all, How to rename the user created database objects in SQL Server 2005?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
| |||
| 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. |
| |||
| 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'; |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Server 2005 | kingmaker | Database Support | 100 | 03-22-2008 02:08 AM |
| Server Assessment for Sql server 2005? | arjkhanna | Server Management | 3 | 10-30-2007 11:09 AM |
| SQL Server 2000 to 2005 | S.Vinothkumar | Database Support | 3 | 09-27-2007 04:22 AM |
| What is a Linked Server in sql server 2005? | Archer | Database Support | 2 | 08-14-2007 04:24 AM |
| When providing a user defined key class for storing objects in the HashMaps or.... | oxygen | Java Programming | 1 | 07-26-2007 04:51 AM |