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

What is the default order of an order by clause?

997

Explain about Views?

1070

What do you understand by coalesce in sql server?

1072

What is advantage data architect?

924

What are the recovery models for a database?

1107

What is table join?

1119

What does truncate do?

937

What are data regions?

135

Explain primary key in sql server?

1019

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3874

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1017

How to list all field names in the result set using mssql_field_name()?

914

What is triggers in ms sql server?

1119

How to start and end transact-sql statements?

1030

How many types of functions are there in sql server?

946