How can i change the column name.

Answer Posted / dipti sonawane

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by table and field in sql?

547


Why we need to use secondry database file? though, we can do same work using primary database file also.

5755


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

533


How can we get count of the number of records in a table?

539


How will you find out if there are expensive SQL statements running or not?

572






Explain features of analysis services?

517


What are the different sql server versions?

512


Define self join?

622


Why do we use trigger?

550


What is the server name for sql management studio?

472


What is a trigger? Why we need it?

527


Explain what is cte (common table expression)?

621


Can you create a logon trigger in sql server 2005 express edition?

569


What is surrogate key? : sql server analysis services, ssas

689


What do you understand by the denormalisation?

547