Alter table Modify

This command is used to alter table existing data type.By giving this command we can change the parameter of  an  table.

ALTER TABLE table_name  MODIFY column_name column_type;

alter table emp modify id number(20);

Leave a Reply

Your email address will not be published. Required fields are marked *