Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic management
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01544563
Message ID:
01544580
Views:
41
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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform