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
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