Sunday, August 2, 2015

SQL Tutorial - lesson 21 - Alter

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;

No comments:

Post a Comment