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
How to use subqueries in the from clause in ms sql server?
Tell me what is difference between view and materialized view?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is ddl command?
Explain Geometry datatype in sql server 2008 with example
List out what other servers you can use with ssrs?
Mention the differences between substr and charindex in sql server.
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
How to define output parameters in stored procedures?
What is the purpose of forms?
What is the use of sign function?
What is merge statement?
How to scale out a federation by Sql statement?
What is the difference between a local and a global temporary table?
What is the difference between ddl and dml?