MS SQL Server Concepts and Programming Question: Download MS SQL Server PDF

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

Answer:

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 > GlobalGuideLineDatabase > 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.

Download MS SQL Server PDF Read All 394 MS SQL Server Questions

Previous Question	Next Question
How to rename an existing column with the "sp_rename" stored procedure in MS SQL Server?	How to change the data type of an existing column with "ALTER TABLE" statements in MS SQL Server?