Removing autoincrement from the column.

I have a table (generated by liquibase) with autoIncrement column. I would now like to change the column so it would no longer increment automatically. I have seen addAutoIncrement tag but no corresponding remove or drop tag.

Is there a way to do that?

Thanks,
Dalibor

We don’t have a corresponding drop tag currently.  You’ll have to go with the tag and write the SQL yourself.

Nathan

As I am trying to support various databases this approach can get quite tedious. But if there is no other option I guess I’ll have to go for it.
Are there any plans to introduce a drop tag in the future?

I added a feature request for it (http://liquibase.jira.com/browse/CORE-486), but it won’t make it for the 2.0 release. 

You can create a custom change http://www.liquibase.org/manual/custom_refactoring_class to make your own to support your databases and uses until the official version is created.

Nathan

Was this ever implemented?