Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DELETING by FK
Message
De
20/11/1998 13:13:16
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
DELETING by FK
Divers
Thread ID:
00159851
Message ID:
00159851
Vues:
63
I have a situation where I need to delete records
based on any one of 100 foreign keys. A total of
about 400,000 records need to be purged.

What is the best way to achieve this goal. I could
do a DELETE FOR INLIST(fk, 2,5,7,8,9,...xxx) but inlist
is limited to 24 expressions.

Perhaps a DELETE FROM tablex WHERE fk IN (sub query)
is the best...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform