Monday, May 29, 2017

How to add more than one column in a table in RDBMS

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); 

No comments:

Post a Comment