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