How to remove column attribute by liquibase?

Question

I have a column attribute

on update CURRENT_TIMESTAMP

How can I remove it in xml changeset ? Database is mysql.

Answer 1

If a refactor operation doesn't exist you can always fall back to a sql

<changeSet author="me" id="example-001">
    <sql dbms="mysql">ALTER TABLE xxx MODIFY COLUMN yyy ????</sql>
</changeSet>