MS SQL Server Concepts and Programming Question: Download Questions PDF
How to rename an existing column with the "sp_rename" stored procedure in MS SQL Server?
![MS SQL Server Interview Answer MS SQL Server Interview Question](https://globalguideline.com/public/images/interview/13.png)
Answer:
If you have an existing column in a table and you want to change the column name, you can use the "sp_rename ... 'COLUMN'" stored procedure. "sp_rename" allows you to change names of COLUMN, DATABASE, INDEX, USERDATATYPE, and OBJECT. The tutorial example below shows you how to rename a column:
USE master
GO
sp_rename 'tip.subject', 'title', 'COLUMN'
GO
Msg 15248, Level 11, State 1, Procedure sp_rename, Line 213
Either the parameter @objname is ambiguous or the claimed
@objtype (COLUMN) is wrong.
USE GlobalGuideLineDatabase
GO
sp_rename 'tip.subject', 'title', 'COLUMN'
GO
Caution: Changing any part of an object name could break
scripts and stored procedures.
SELECT id, title, description, author FROM tip
GO
id title description author
1 Learn SQL Visit www.globalguideline.com NULL
You are getting the first error because 'GlobalGuideLineDatabase' is not the current database.
USE master
GO
sp_rename 'tip.subject', 'title', 'COLUMN'
GO
Msg 15248, Level 11, State 1, Procedure sp_rename, Line 213
Either the parameter @objname is ambiguous or the claimed
@objtype (COLUMN) is wrong.
USE GlobalGuideLineDatabase
GO
sp_rename 'tip.subject', 'title', 'COLUMN'
GO
Caution: Changing any part of an object name could break
scripts and stored procedures.
SELECT id, title, description, author FROM tip
GO
id title description author
1 Learn SQL Visit www.globalguideline.com NULL
You are getting the first error because 'GlobalGuideLineDatabase' is not the current database.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD" in MS SQL Server? | How to rename an existing column with SQL Server Management Studio? |