This example renames the contact title column in the customers table to t

How can i change the column name.

Question Posted / y.narendra kumar

Answer Posted / y.narendra kumar

This example renames the contact title column in the
customers table to title.

EXEC sp_rename 'customers.[contact
title]', 'title', 'COLUMN'

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many triggers you can have on a table?

993

What are sql dirty pages?

1018

What is difference between delete & truncate commands?

1081

What is difference between temp table and cte?

1015

What is a performance monitor?

976

Are null values the same as that of zero or a blank space?

1036

How to write a query with a right outer join in ms sql server?

913

List out a number of the wants to setup a SQL Server failover cluster?

1070

Explain the truncate command? : SQL Server Architecture

1168

What is it unwise to create wide clustered index keys?

1007

Is it safe to delete log files?

918

How to generate create function script on an existing function?

1111

Tell me the difference between clustered and non-clustered index?

935

How to list all login names on the ms sql server?

1139

List out the differences between global and local temp tables in sql server?

1058