Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scripting Triggers and Indexes
Message
From
17/08/2001 10:53:20
 
 
To
All
General information
Forum:
Visual Basic
Category:
SQL Server
Title:
Scripting Triggers and Indexes
Miscellaneous
Thread ID:
00545339
Message ID:
00545339
Views:
36
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)
Next
Reply
Map
View

Click here to load this message in the networking platform