Answer Posted / praveen kumar.dandu
suppose we had a table name emp and columns ename and sal.
<sql>alter table emp rename column sal to salary;
it wll rename the column sal to salary
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
What do you mean by an execution plan? Why is it used? How would you view it?
What are the five major components of a dbms?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What command is used to rename the database?
Explain linked server in sql?
What protocol does sql server use?
How to generate create table script on an existing table in ms sql server?
How many triggers are possible per table?
What are the character string functions supported by sql server 2005?
Explain syntax for disabling triggers?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Can sql server be linked with other servers like oracle?
What is the purpose of sql profiler in sql server?
What are the grouping functions?
How to return the second 5 rows in ms sql server?
