Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dynamic management
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01544563
Message ID:
01544580
Vues:
42
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform