Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wipe out all triggers in dbc
Message
De
07/05/2012 14:12:16
 
 
À
07/05/2012 13:18:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01543257
Message ID:
01543262
Vues:
66
You can always do this ;-)
SET SAFETY OFF
USE TheDbc.DBC IN 0 ALIAS TheData EXCLUSIVE
SELECT TheData
ZAP
USE
>did not find it in alter table but this seems to work:
>
>	DELETE TRIGGER ON (x1) FOR DELETE 
>	DELETE TRIGGER ON (x1) FOR INSERT
>	DELETE TRIGGER ON (x1) FOR UPDATE
>
>
>Thanks
>
>Peter
>
>
>>>i forgot how to diagrammatically clear all triggers in a dbc
>>>
>>>
>>>is this done with
>>>
>>>alter table
>>>
>>>
>>>Thanks
>>>
>>>
>>>Peter
>>
>>Yes, check ALTER TABLE command syntax in VFP Help
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform