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

Differentiate between delete and truncate.

994

What is normalization? Explain different forms of normalization?

1070

Define outer join in sql server joins?

889

What is tablesample?

1027

What is a partition function in sql server?

1023

Difference between primary key and clustered index?

933

What is the difference between the 2 operating modes of database mirroring?

1056

List out different types of normalizations in sql server and explain each of them?

886

What is difference between group by and having?

908

what is isolation level at dead lock?

2088

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8109

Explain the relational database management system (rdbms)?

1018

How do you set a trace flag in sql server?

996

Where are stored procedures in sql server?

1007

Can we do dml on views?

914