>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
Timothy Bryan