Update type of a column in liquibase

Chris311 picture Chris311 · Sep 12, 2013 · Viewed 19.5k times · Source

I want to update the type of a column named "password". At the moment it has type NVARCHAR(40) and I want it to be of type NVARCHAR(64). This is what I did:

<changeSet id="1 - change password length" author="chris311">
    <update tableName="tablename">
        <column name="password" type="NVARCHAR(64)"/>
    </update>
</changeSet>

What else is there to do? Because this obviously does not change anything in the DB.

Answer

Mark O&#39;Connor picture Mark O'Connor · Sep 13, 2013

You're using the wrong refactoring operation. Try modifyDataType