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

09-02-2006, 09:08 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 :)

09-08-2006, 08:26 AM
You can add a new field using ALTER TABLE statement

ALTER TABLE table_name ADD column_name datatype


ALTER TABLE Employee ADD City varchar(30)

* All the capital letters are reserved words