How can we change the name and data type of a column of a
table?

Answer Posted / nithya

To change the name of the column:

ALTER TABLE TABLENAME RENAME COLUMN OLD_COLUMN_NAME TO
NEW_COLUMN_NAME;

eg: alter table employee rename column emp_name to ename;

To change the datatype of a column:

ALTER TABLE TABLENAME MODIGY COLUMN_NAME NEW_DATA_TYPE;

eg: alter table employee modify ename varchar(50);

NOTE: u cannot modify column of a datatype from larger value
to smaller value.U can do it only if there is no data in ur
column.

eg: alter table employ_detail modify emp_addr varchar(5);

ORA-01441: cannot decrease column length because some value
is too big

alter table employ_detail modify emp_id number(2)

ORA-01440: column to be modified must be empty to decrease
precision or scale

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different types of constraints?

498


How can you increase the performance of mysql select query?

467


How do I view a mysql database?

460


Can mysql handle big data?

501


How to control the max size of a heap table?

530






What is general log in mysql?

441


What is mysql slow query?

500


How to load data files into tables with 'mysqlimport'?

451


What is database migration in mysql?

502


What does tinyint mean?

491


Can I use mariadb instead of mysql?

470


What is the limitation of mysql?

462


Is postgresql better than mysql?

484


How to create and drop view in mysql?

493


What is the use of pdo?

490