ALTER TABLE <owner_name.tab_name> RENAME COLUMN <old

How can we change the name of a column of a table?

Question Posted / chandrakant agrawal

7 Answers
10622 Views
I also Faced
E-Mail Answers

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

How can I connect mysql database?

848

What is difference between mysql_connect and mysql_pconnect?

973

What are stored procedures and functions?

855

What is query log in mysql?

899

What is a user defined variable?

844

What does mysql flush tables do?

906

how to take mysql database backup?

999

What is 'mysqld'?

876

Can you tell what are various ways to create an index?

817

Is mysql a backend?

877

Write a query to fetch common records between two tables using mysql?

957

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

906

What is clob in mysql

887

What is the difference between float and double?

1047

How many mysql connections can handle?

848