Collections:
Renaming an Existing Column with Management Studio in SQL Server
How to rename an existing column with SQL Server Management Studio in SQL Server?
✍: FYIcenter.com
If you are using SQL Server Management Studio, you can rename almost any data objects through the Object Explorer window. The tutorial example below shows you how to rename a column:
1. Run SQL Server Management Studio and connect to SQL server.
2. On the Object Explorer window, follow the object tree: Databases > FyiCenterData > Tables > dbo.tip > Columns > title.
3. Click right mouse button on "title". The context menu shows up.
4. Select "Rename", type "subject" over "title", and press Enter key. The column name will be changed.
⇒ "ALTER TABLE ... ALTER COLUMN" - Changing Column Data Type in SQL Server
⇐ "sp_rename ... 'COLUMN'" - Renaming an Existing Column in SQL Server
2016-11-15, 1545🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...