Adding Columns to a Table

[BiancaJ]

Can I add a column to a database table without dropping and recreating the table?

The problem is that everytime a user creates an action that requires a new table - at the moment I drop the table and recreate the table with the new column.

This requires lots of resources as I have to populate the table again.

Is there a design way I can go around this?

 

[SQLBill]

Check out the Books OnLine, go to the Index tab and search on ALTER TABLE.


ALTER TABLE tablename
ADD COLUMN column_name <datatype>


example

ALTER TABLE mytable
ADD COLUMN mynewcolumn VARCHAR(10) NULL

-SQLBill