MS SQL Server Concepts and Programming Question:

How to rename an existing column with the "sp_rename" stored procedure in MS SQL Server?

MS SQL Server Interview Question
MS SQL Server Interview Question

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.


Previous QuestionNext 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?