Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Liquibase change existing nullable constraint from true to false

Tags:

I added a column to an existing table using Liquibase changelog, and I set the nullable constraint to true.

Code:

<changeSet id="10" author="000000">
    <addColumn tableName="NCV_ATTRIBUTE">
        <column name="AlternativeListPrice" type="double" defaultValue="0.0">
        <constraints nullable="true"/>
        </column>
    </addColumn>
</changeSet>

I want to change the nullable constraint from true to false in changeSet 11. What is the simplest way to achieve this?

Thanks.