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
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?