>SSMS is generic tool and as such it quite often unnecessarily works the way you describe instead of just using ALTER TABLE. It could be quite expensive on big tables.
>
>>BTW you could see what SSMS does when you alter/add a new fields in a table. It first rename the table then create the new one with the same name, add all constraints and insert records from renamed table to the new one and finally drop the old table.
Yes it is.
But sometimes its way is easier.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
