Renaming an Existing Column with Management Studio in SQL Server

Q

How to rename an existing column with SQL Server Management Studio in SQL Server?

✍: FYIcenter.com

A

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.

 

⇒Managing Tables and Columns in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-15, 938👍, 0💬