PDA

View Full Version : How to add new column to an existing table


yoyali
09-02-2006, 10:13 AM
Hi everyone,
I need help in this matter. I have this form in which the user insert his details, and chose which detail to add and which not and he can add a new field by his own which doesn't exist before. So this new field is a new column, so I just want to know how to add this column into an existing table.
I'm using sql server 2000
Many Thanx
Yoya :)

BarrMan
09-04-2006, 04:46 PM
INSERT INTO ur_table (field1,field2,field3) VALUES ('value1','value2', 'value3')

Spudhead
09-04-2006, 04:51 PM
ALTER TABLE [myTable] ADD [MyColumn] varchar(30)

BarrMan
09-04-2006, 04:58 PM
Oh! right... sorry... That's what you mean :/.
Sorry for misunderstanding.