dropNotNullConstraint

Makes a column nullable.

Available attributes

Name	Description	Required for	Supports	Since
`catalogName`	Name of the catalog		all	3.0
`columnDataType`	Current data type of the column	informix, mariadb, mssql, mysql	all
`columnName`	Name of the column to drop the constraint from	all	all
`schemaName`	Name of the schema		all
`tableName`	Name of the table containing that the column to drop the constraint from	all	all

XML example

<changeSet  author="liquibase-docs"  id="dropNotNullConstraint-example">  
    <dropNotNullConstraint  catalogName="cat"  
            columnDataType="int"  
            columnName="id"  
            schemaName="public"  
            tableName="person"/>  
</changeSet>

YAML example

changeSet:  
  id:  dropNotNullConstraint-example  
  author:  liquibase-docs  
  changes:  
  -  dropNotNullConstraint:  
      catalogName:  cat  
      columnDataType:  int  
      columnName:  id  
      schemaName:  public  
      tableName:  person

JSON example

{
  "changeSet":  {
    "id":  "dropNotNullConstraint-example",
    "author":  "liquibase-docs",
    "changes":  [{
      "dropNotNullConstraint":  {
        "catalogName":  "cat",
        "columnDataType":  "int",
        "columnName":  "id",
        "schemaName":  "public",
        "tableName":  "person"
      }
    }]
  }
}

SQL example

ALTER  TABLE  cat.person  MODIFY  id  INT  NULL;

Database support

Database	Notes	Auto rollback
DB2/LUW	Supported	Yes
DB2/z	Not Supported	No
Derby	Supported	Yes
Firebird	Not Supported	No
H2	Supported	Yes
HyperSQL	Supported	Yes
INGRES	Supported	Yes
Informix	Supported	Yes
MariaDB	Supported	Yes
MySQL	Supported	Yes
Oracle	Supported	Yes
PostgreSQL	Supported	Yes
Snowflake	Supported	Yes
SQL Server	Supported	Yes
SQLite	Not Supported	No
Sybase	Supported	Yes
Sybase Anywhere	Supported	Yes