Thursday, 28 December 2017

Alter table command

Alter table command
Alter table command is used to modify the defination of table by modifying the table column .
Alter table statement can be used to delete, add and modify the existing table.

alter table emp add  test111  int

alter table emp drop column test111