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

How to connect ms access to sql servers through odbc?

1030


what is unique and xaml nonclustered index

1051


What do you mean by subquery?

1088


What is create command?

974


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1916


Explain various On-Delete options in a DB table. Which is the default option?

1468


What is shared lock?

905


Define self join?

1032


What are the reporting services components?

142


Explain syntax for disabling triggers?

1044


What are the extra roles available in msdb? : sql server security

1135


What does COMMIT command do?

1067


Does a specific recovery model need to be used for a replicated database? : sql server replication

964


what authentication modes does sql server support? : Sql server database administration

1115


what is the main function of a query parameter?

152