addDefaultValue

Adds a default value to the database definition for the specified column. One of defaultValue, defaultValueNumeric, defaultValueBoolean or defaultValueDate must be set.

Available attributes

Name	Description	Required for	Supports
catalogName	Name of the catalog		all
columnDataType	Current data type of the column to add default value to	informix	all
columnName	Name of the column to add a default value to	all	all
defaultValue	Default value. Either this property or one of the other defaultValue* properties are required.		all
defaultValueBoolean			all
defaultValueComputed			all
defaultValueConstraintName			all
defaultValueDate			all
defaultValueNumeric			all
defaultValueSequenceNext			all
schemaName	Name of the schema		all
tableName	Name of the table to containing the column	all	all

XML example

<changeSet  author="liquibase-docs"  id="addDefaultValue-example">  
    <addDefaultValue  catalogName="cat"  
            columnDataType="varchar(50)"  
            columnName="fileName"  
            defaultValue="Something Else"  
            defaultValueBoolean="true"  
            defaultValueComputed="now"  
            defaultValueConstraintName="A String"  
            defaultValueDate="2008-02-12T12:34:03"  
            defaultValueNumeric="439.2"  
            defaultValueSequenceNext="seq_name"  
            schemaName="public"  
            tableName="file"/>  
</changeSet>

YAML example

changeSet:  
  id:  addDefaultValue-example  
  author:  liquibase-docs  
  changes:  
  -  addDefaultValue:  
      catalogName:  cat  
      columnDataType:  varchar(50)  
      columnName:  fileName  
      defaultValue:  Something Else  
      defaultValueBoolean:  true  
      defaultValueComputed:  now  
      defaultValueConstraintName:  A String  
      defaultValueDate:  2008-02-12T12:34:03  
      defaultValueNumeric:  '439.2'  
      defaultValueSequenceNext:  seq_name  
      schemaName:  public  
      tableName:  file

JSON example

{  "changeSet":  {  "id":  "addDefaultValue-example",  "author":  "liquibase-docs",  "changes":  [  {  "addDefaultValue":  {  "catalogName":  "cat",  "columnDataType":  "varchar(50)",  "columnName":  "fileName",  "defaultValue":  "Something Else",  "defaultValueBoolean":  true,  "defaultValueComputed":  "now",  "defaultValueConstraintName":  "A String",  "defaultValueDate":  "2008-02-12T12:34:03",  "defaultValueNumeric":  "439.2",  "defaultValueSequenceNext":  "seq_name",  "schemaName":  "public",  "tableName":  "file"  }  }]  }  }

SQL example

ALTER  TABLE  cat.file  ALTER  fileName  SET  DEFAULT  'Something Else';

Database support

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