alter table in sql | Sharp Tutorial

SQL Table alter

alter table is the command to modify the structure of the table. Add new column or delete existing column

new column may be added in the table Syntax: alter table add(field-name type(size), field2,….);

   alter table login add (usermode varchar(20));

Above query add a new column in the given table as per following.

existing column may be deleted from the table Syntax: alter table drop(field-name , field2,….)

    alter table login drop type;

Above query deletes a column from the given table as per following.select ok after execution the query.