Tuesday, June 10, 2014

How to add multiple columns once time

Hi All, Today I want to show how to add new fields at one time by multiple columns. This is an example using add new field. Enjoy .....................


CREATE TABLE test1( col1 int );
ALTER TABLE test1 ADD COLUMN col2 VARCHAR(40), ADD COLUMN col3 int, ADD COLUMN col4 TIMESTAMP, ADD COLUMN col5 NUMERIC, ADD COLUMN col6 BIT;

No comments:

Post a Comment