sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn ame

How can i change the column name.

Question Posted / desh deepak

Answer Posted / desh deepak

sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What types of replication are supported in sql server?

1063

Does order by actually change the order of the data in the tables or does it just change the output?

1147

when you create a database how is it stored? : Sql server database administration

1025

What are the different types of triggers in SQL SERVER?

1139

Can I use sql azure as a backup with log shipping or database mirroring?

156

how many clustered indexes can be created on a table? : Sql server database administration

1152

Can we use pragma autonomous_transaction in trigger?

962

Explain the collation?

1112

How to use group functions in the select clause in ms sql server?

1055

What is msdb database? : SQL Server Architecture

1134

How many types of triggers in sql server?

1032

Give an example of SQL injection attack ?

1006

What are the filtered indexes?

1040

How do you manipulate data?

910

what is the sql equivaent of the dataset relation object ?

2027