>>Look at ALTER TABLE ADD COLUMN syntax in BOL.
>
>I do know how to do that much in DDL but it is a bit silly to even have SSMS if I can't design my table there. I could certainly do that before I upgrade from SQL 2005 to SQ 2008. I guess I need to explore the options and settings to find a way to enable the use of the tool.
>Thanks Naomi.
>Tim
See my other reply - I already found this option. Yet in your particular case it may be better to go with ALTER TABLE command.
BTW, I updated my previous reply - please re-read.
If it's not broken, fix it until it is.
My Blog