Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Zap a table.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00397610
Message ID:
00397681
Vues:
10
Yikes! I didn't realize that. Do you know the reasoning behind that? I didn't think you could do anything without the triggers firing

I think the reasoning is if you want to get rid of all the records in a parent table, you probably want to get rid of all the records in child tables as well, and ZAPping them is virtually immediate regardless of table size, whereas DELETE ALL and having the trigger fire for each record could take an incredibly long time for large tables.
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform