Thursday, April 7, 2011

Add New column in Table

To Add New Column In Table  . Use Following Sql Query

Query:- " Alter table 'TableName'  Add Column 'CoulmnName' 'DataType'

Exp:-
Let Assume My Table name is TempTable and i want to add New Column with Name of EmpAdd

Query:  Alter table temptable add column empadd varchar(50)


Choice is yours...... Cheers

Kapil hasija