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

What is unique key in mysql?

988


Can foreign key have duplicate values?

888


What is a user defined variable?

913


Is primary key auto increment?

946


What is tee command in mysql?

950


Why do we need mysql?

971


What is InnoDB?

1097


how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

905


What is slow query log in mysql?

1104


what is cte? : Mysql dba

945


How do I start mysql?

889


Can mysql function return a table?

1092


What is sql in mysql?

1031


Which datatype is used for email in mysql?

958


What are features of mysql?

890