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 can we change the name of a column of a table?

Answer Posted / chandrakant agrawal

ALTER TABLE <owner_name.tab_name> RENAME COLUMN <old_name>
TO <new_name>;


We can also modify the datatype,size of the column using
command alter table

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can you elaborate on blob and text in mysql? : Mysql dba

897


How to use in conditions?

1013


Why do we need mysql?

977


Why is mysql popular?

890


What is procedures in mysql?

940


Why do we use preparedstatement?

933


What is the date format in mysql?

892


How to get the number of rows selected or affected by a sql statement?

921


what is the difference between between and in operators in mysql?

1033


What is max connection in mysql?

933


What are queries used for?

954


What is mysqlcheck do?

1027


Do while loop in mysql procedure?

1077


What are the mysql database files stored in system ?

1064


Why we use mysql workbench?

911