>>>There was another thread on the same forum and by default SSMS tries to re-create the table (if you do it from the designer) instead of the simple ALTER TABLE command.
>>>
>>>Anyway, I found how you can change this option (menu Tools\Options).
>>>
>>>See attached screen.
>>
>>Thanks Naomi,
>>
>>Question. Is it normal to drop a table and re-create it when you just need to add a column? Seems like a bit of a nuclear approach to table management.
>>Tim
>
>No, it's not normal. It is just the way SSMS is doing it. Why it's doing it this way - I'm not sure. I can try to search for the discussion on this topic on that board if you're interested.

No, thats OK Naomi. I guess what is important is that I know it now, so will use it judiciously.
Thanks
Tim