If you want to modify the existing table to add, modify or delete columns then you use Alter table.
using Alter you can modify the existing table, add a column, delete a colum
Syntax:
Alter table emp add dateofbirth date;
using Alter you can modify the existing table, add a column, delete a colum
Syntax:
Alter table emp add dateofbirth date;
No comments:
Post a Comment