Syntax:
ALTER TABLE table_name
ADD column_name1 column-definition;
column_name2 column-definition;
.........................
column_nameN column-definition;
Example:
ALTER TABLE supplier
ADD supplier_name varchar(50);
City varchar(50);
ALTER TABLE table_name
ADD column_name1 column-definition;
column_name2 column-definition;
.........................
column_nameN column-definition;
Example:
ALTER TABLE supplier
ADD supplier_name varchar(50);
City varchar(50);
No comments:
Post a Comment