ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

How can i change the column name.

Question Posted / sanjay

13 Answers
22705 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

Can we use trigger new in before insert?

865

What is acid db?

840

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

989

Tell me about normalization in DBMS.

947

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

914

What are the five characteristics of good data?

869

Explain user defined views?

912

What is the purpose of the master database?

1052

What is single-user mode?

868

What is the default server name for sql server?

1088

What is difference between getdate and sysdatetime in sql server 2008?

999

What are rest-style architecture's?

170

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1575

What is row-level compre?

941

What is the boxing and unboxing concept in .net?

866