IT Community - Software Programming, Web Development and Technical Support

To rename user created objects in sql server 2005

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?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 03-06-2008, 08:27 PM
vadivelanshanmugam vadivelanshanmugam is offline
D-Web Trainee
 
Join Date: Jan 2008
Posts: 36
vadivelanshanmugam is on a distinguished road
Default To rename user created objects in sql server 2005

Hi all,

How to rename the user created database objects in SQL Server 2005?
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 03-06-2008, 08:28 PM
vadivelanshanmugam vadivelanshanmugam is offline
D-Web Trainee
 
Join Date: Jan 2008
Posts: 36
vadivelanshanmugam is on a distinguished road
Default Re: To rename user created 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.
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 03-06-2008, 08:29 PM
vadivelanshanmugam vadivelanshanmugam is offline
D-Web Trainee
 
Join Date: Jan 2008
Posts: 36
vadivelanshanmugam is on a distinguished road
Default Re: To rename user created objects in sql server 2005

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

sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name'
[ , [ @objtype = ] 'object_type' ]
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 03-06-2008, 08:30 PM
vadivelanshanmugam vadivelanshanmugam is offline
D-Web Trainee
 
Join Date: Jan 2008
Posts: 36
vadivelanshanmugam is on a distinguished road
Default Re: To rename user created objects in sql server 2005

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';
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 2000 migration to SQL Server 2005 Collation Change - Method? arjkhanna Database Support 5 10-02-2009 09:58 PM
user server/ip time? joebratcher1 PHP Programming 0 12-29-2008 10:16 AM
Server Assessment for Sql server 2005? arjkhanna Server Management 3 10-30-2007 10:09 AM
What is a Linked Server in sql server 2005? Archer Database Support 2 08-14-2007 03:24 AM
When providing a user defined key class for storing objects in the HashMaps or.... oxygen Java Programming 1 07-26-2007 03:51 AM


All times are GMT -7. The time now is 08:29 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0