Alter Table

[RichB]

I am familiar with the ALTER TABLE string and have used it frequently. My question is. Can you add multiple columns in one string currently I add one at a time and create a macro that runs all of the queries to my table. Just trying to clean it up.

Thanks
Rich

 

[Travis]

From what I have read the answer to adding multiple columns with the ALTER Statement is Yes.


Note: Take the time to test this on a Temp table to review the results before implementing.