ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

How can i change the column name.

Question Posted / sanjay

13 Answers
23292 Views
HCL, Yardi Software, I also Faced
E-Mail Answers

Answer Posted / sanjay

ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rename databases in ms sql server?

1209

Please explain go command in sql server?

1062

How to insert data with null values?

1039

What are the new scripting capabilities of ssms? : sql server management studio

1070

Can we add our custom code in ssis?

994

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1122

what information is maintained within the msdb database? : Sql server administration

981

How do I find information about the install locations for the various instances running on a computer?

1086

How to skip remaining statements in a loop block using continue statements?

1003

What is log shipping?

964

What is the partitioning method?

1024

What are the fixed server level roles? : sql server security

1141

What is ems sql management studio? : sql server management studio

1114

Write down the syntax and an example for create, rename and delete index?

991

List out some of the requirements to set up a sql server failover cluster?

1034