HOW TO RENAME A COLUMN NAME

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


Please Help Members By Posting Answers For Below Questions

How to create a user name in a database?

584


Explain what are commit and rollback in sql?

526


what is the maximum size of a row? : Sql server database administration

531


What extended events?

544


When cursors are useful?

573






What is an sql server agent?

542


How many partitions a clustered index has by default in sql server 2012?

659


How to enter comments in transact-sql statements?

547


What is the importance of concurrency control?

662


What is function of ROLLUP ?

650


How to create and drop temp table in sql server?

586


wat wil hapn if we give the both read and deny read permission to user?

1653


how many no of arguments can be passed in procedures and functions

4776


What is an execution plan?

564


What are the 3 types of schema?

597