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
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
What is the difference between timestamp and datetime in mysql?
What is mysql in dbms?
How Switch (select or use) to a database.
What is text in mysql?
What is difference between function and procedure in mysql?
What is a simple query?
Is mariadb better than mysql?
What are the different data types in mysql?
What is session variable in mysql?
Is mongodb faster than mysql?
What is the difference between sql and mysql and oracle?
What is database engine in mysql?
What are the benefits of mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba