Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What function does a database engine serve in the sql server?

1004


Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

980


How to add a new dsn with the odbc driver for sql server?

1022


What is the optimization being performed in oracle and SQL Server?

1021


Write a SQL queries on Self Join and Inner Join.

1004


How to link tables in sql server?

905


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1104


How to insert data with null values?

988


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1004


Describe how to use the linked server?

1091


What is an indice?

999


How to check parameter value in stored procedure sql server?

937


mention different types of relationships in the dbms?

983


SQL Server Architecture ?

2413


What is optimization and its types?

931