Detect duplicate keys:
http://common-schema.googlecode.com/svn/trunk/common_schema/doc/html/redundant_keys.htmlSELECT redundant_index_name, sql_drop_index FROM redundant_keys; +----------------------+----------------------------------------------------------+ | redundant_index_name | sql_drop_index | +----------------------+----------------------------------------------------------+ | rental_date_2 | ALTER TABLE `sakila`.`rental` DROP INDEX `rental_date_2` | +----------------------+----------------------------------------------------------+
0 comments:
Post a Comment