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 are partitioned views?
What command is used to delete a table from the database in the sql server and how?
Explain temporary table vs table variable by using cursor alternative?
What is Cross Join and in which scenario do we use Cross Join?
What part does database design plays a role in performance of an sql server-based application?
How to join two tables in a single query in ms sql server?
What is the difference between functions and scalar functions?
What is serializable?
Describe the left outer join & right outer join. : sql server database administration
What are the differences between lost updates and uncommitted dependencies?
What are clustered and non-clustered index?
What is a data collection table?
What is the use of stored procedure?
What is the template in sql?
Do you know exporting and importing utility?