The Alter Table Query in SQL modifies the
existing table 'Stu_Table' and add a multiple columns to the
existing table. In this example, we add columns 'Stu_dob' and 'Stu_Address'
to the existing table 'Stu_Table'.

Alter Table Stu_Table add (Stu_dob date, Stu_Addreass varchar(20));

Describe Stu_Table

The Describe Stu_Table show you the new fields
added to the table'Stu_Table'.

surabhi chugh
April 11, 2013
query
how to insert values in an altered table...like in the above example table stu_table has been altered...now how will we insert values in the column stu_job and stu_address