alter table (table_name) change (old_colomnname)(new

How can i change the column name.

Question Posted / dipti sonawane

Answer Posted / dipti sonawane

alter table (table_name)
change (old_colomnname)(new_colomnname)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between rownum and rowid?

956

Explain external key management in sql server 2008

935

How to rebuild master databse?

1127

How to transfer data from a cursor to variables with a "fetch" statement?

1143

What is the difference between varchar and nvarchar datatypes?

1142

According to you what goes into making the best database administrator? : sql server database administration

1022

What are the ways available in sql server to execute sql statements?

1205

What is the latest version of microsoft sql server?

1116

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1351

What is the difference between upgrade and migration in sql server?

1150

How do I know if localdb is running?

999

What is format parameter in ssrs?

150

What are the purposes and advantages stored procedure?

1018

What is rtm version in sql server?

1103

How to delete duplicate records based on single column from a table?

1105