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, 2206🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...