Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Removing Ref Integrity
Message
 
À
08/05/2001 06:18:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00504603
Message ID:
00504608
Vues:
12
Hi there.

If it's a VFP Database then you can open it up in the vdp Database Designer and have a look at the RI and even the stored procedures.
U might want to check if columns referenced in the RI are Indexed for faster access especially when there are lookups.

Normaly Deleting RI might not give a problem if it is only to maintain RI and not update values in referencing tables. Maintaining RI can be done at the fron end also and so can be the updating. U have to take care that updates to tables other than the tables whose RI u want to delete are not referenced in the RI procedure.

Hope this helps.
Regards
Hiten K M

( The best and the worst are yet to come .. keep coding ! )

My Resume >>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform