Collections:
"sp_rename ... 'COLUMN'" - Renaming an Existing Column in SQL Server
How to rename an existing column with the "sp_rename" stored procedure in SQL Server?
✍: FYIcenter.com
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 FyiCenterData 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 dev.fyicenter.com NULL
You are getting the first error because 'FyiCenterData' is not the current database.
⇒ Renaming an Existing Column with Management Studio in SQL Server
⇐ "ALTER TABLE ... DROP COLUMN" - Deleting Existing Columns in SQL Server
2016-11-17, 2341🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...