Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scripting Triggers and Indexes
Message
De
17/08/2001 14:34:16
 
 
À
17/08/2001 11:35:21
Information générale
Forum:
Visual Basic
Catégorie:
SQL Server
Divers
Thread ID:
00545339
Message ID:
00545564
Vues:
15
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform