Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Zap a table.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00397610
Message ID:
00397681
Views:
9
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform