How to delete an index in Grails with Liquibase

database grails migration gorm liquibase
nightingale2k1 picture nightingale2k1 · Nov 6, 2009 · Viewed 25k times · Source

I have a table generated by GORM (Grails Domain). It has foreign key / index that generated random characters like FKAC7AAF67162A158F. I need to remove that field that not needed anymore.

The problems, I have some servers that need to be updated. So I need to create a migration using Liquibase. But I have no idea how to remove that index manualy if the index are in random name (each server my have different name).

is it possible to drop an index of something without knowing its name ?

Answer

Frank DeRosa picture Frank DeRosa · Nov 6, 2009

According to the MySQL Manual...

SHOW INDEX FROM mydb.mytable;

will return information about the mytable. It returns several fields with info about the table and its index, including a Column_name and key_name fields. You can probably sort out which one you need.

After that, you should be able to execute this:

DROP INDEX index_name ON tbl_name

And boom, no more index.

Related questions

how to insert html tag inside sql in Liquibase migration?

I need to update my data that have html tag inside so wrote this on liquibase <sql> update table_something set table_content = " something <br/> in the next line " </sql> it apparently doesn't work …

Read More
SQL/Database Views in Grails

Does anybody know what is the best approach to accessing a sql view through Grails (or if this is even possible)? It seems an obvious way of doing this would be to use executeQuery against the view to select a …

Read More
How to connect Grails 3.0 to my local Mysql database

I'm quite new with Grails and trying to connect my application to my local mysql database. Since I'm working with the latest version of Grails, I couldn't really find a lot of documentation to help me out. Is there any …

Read More