Can I add a column to an existing DB? 1

[Ralph8]

Is it possible to add a column to a production DB using T-SQL?

A customer has added a requirement and I need to add 1 or 2 columns to a DB. They are several hours away and I do not have the capability to "Sign on" via the internet and use EM.

I have looked at the FAQs and the MS Developers page. If the answer is there I missed it.

Any ideas?

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[PatrickIRL]

Although I've never done it I know it can be done using the ALTER TABLE statement. Do a search here for ALTER TABLE, there's plenty of examples.

Patrick

 

[bjd4jc]

Look at the ALTER TABLE statement in Books online.

In basic form it would look similar to

ALTER TABLE TabelName ADD NewField varchar(15)

 

[Ralph8]

Thanks guys. Books on line had a specific example of what I need to do.

TIA

Ralph D. Meredith

http://www.merecosoftware.com