General information
Title:
Scripting Triggers and Indexes
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only