CREATE TABLE Student ( Id INT , Name VARCHAR ( 100 ) ) GO ALTER TABLE Student ADD Standard INT GO ALTER TABLE Student ADD Marks int GO Instead of writing 2 alter query's in above we done using single alter query. ALTER TABLE STUDENT ADD Standard INT , Marks INT GO SELECT * FROM Student GO DROP TABLE Student GO