Re: Drop Index if Exists

2006-09-01 Thread Adam Lipscombe
Thanks What I am getting at is: does the "IF EXISTS" qualifier work in this context? I have an index that is present in some DB's but not in others. I want to run a generic script to upgrade them all. I don't want the script to stop if the index is not present. Thanks - Adam Visolve DB TEA

Re: Drop Index if Exists

2006-09-01 Thread Visolve DB TEAM
Hello Adam,This is the exact syntax to drop the index.DROP INDEX index_name ON tbl_nameThanksVisolve DB Team . - Original Message - From: "Adam Lipscombe" <[EMAIL PROTECTED]> Cc: Sent: Friday, September 01, 2006 3:28 PM Subject: Drop Index if Exists Folks, Does this work in MYSQL 5?