Sorry, did you try combining them with Or like you were doing on your code?
Otherwise, you could generate the drop script first and then the default.
HTH
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement