dropindex & unique

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

dropindex & unique

Post by Thunderstone »




In a webinator database with -unique enabled, after -dropindex is run, should the -unique argument be used with the -index command?

Mike Clark
super@101super.com



User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

dropindex & unique

Post by Thunderstone »



Yes, -dropindex will lose any special index settings. You will need to
re-issue -unique. -unindex won't lose the -unique setting.




Post Reply