Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scripting Triggers and Indexes
Message
De
17/08/2001 10:53:20
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
SQL Server
Titre:
Scripting Triggers and Indexes
Divers
Thread ID:
00545339
Message ID:
00545339
Vues:
43
How can i script all Triggers and Indexes of my db in a vb procedure? i want to generate a script that drop and recreate my triggers and indexs.

for the Views i can use this command :

TheCommand = TheCommand & test.Database(txtDB.Text).Views(X).Script(SQLDMOScript_Default Or SQLDMOScript_Drops)

But there is no such command for the triggers and indexes.

the command i have for the triggers is :

TheCommand = TheCommand & test.Database(txtDB.Text).Tables(X).Script(SQLDMOScript_Triggers)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform