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
What is unique key in mysql?
Can foreign key have duplicate values?
What is a user defined variable?
Is primary key auto increment?
What is tee command in mysql?
Why do we need mysql?
What is InnoDB?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is slow query log in mysql?
what is cte? : Mysql dba
How do I start mysql?
Can mysql function return a table?
What is sql in mysql?
Which datatype is used for email in mysql?
What are features of mysql?