Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scripting Triggers and Indexes
Message
From
17/08/2001 14:34:16
 
 
To
17/08/2001 11:35:21
General information
Forum:
Visual Basic
Category:
SQL Server
Miscellaneous
Thread ID:
00545339
Message ID:
00545564
Views:
12
Thanks for your answer but it doesn't work! it add the 2 options

lOptions1 = SQLDMOScript_Default + SQLDMOScript_Drops
it gives : lOptions1= 4 + 1
so lOptions1 = 5 and it's not the right option!

when i tried them separately it works!
with the option SQLDMOScript_Default, it scripts the indexes for the table
with the option SQLDMOScript_Drops, it drops the indexes from the table

but i need them in one script like :

If indexA exists drop
create indexA
select * from table1

if indexB exists drop
create indexB
select * from table2
...

you know what i mean?

thanks for your time!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform