How can i change the column name.

Answer Posted / om

the alter command is used to do modification at column level . so in order to change the name of a column we need to use alter .

command:- alter table (table name) rename (old column name) to (new column name)
note :- dont put brackets its just for u to understand

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use subqueries in the from clause in ms sql server?

559


Tell me what is difference between view and materialized view?

514


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

117


What is ddl command?

525


Explain Geometry datatype in sql server 2008 with example

574






List out what other servers you can use with ssrs?

89


Mention the differences between substr and charindex in sql server.

509


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

525


How to define output parameters in stored procedures?

510


What is the purpose of forms?

483


What is the use of sign function?

549


What is merge statement?

619


How to scale out a federation by Sql statement?

92


What is the difference between a local and a global temporary table?

614


What is the difference between ddl and dml?

559