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, 2113🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...