Change: ‘addColumn’
Adds a new column to an existing table
Available Attributes
| Name | Description |
|---|---|
| catalogName | Name of the catalog@ v3.0E.g. 'cat' |
| schemaName | Name of the schemaE.g. 'public' |
| tableName | Name of the table to add the column toE.g. 'person' |
Nested Properties
| Name | Description |
|---|---|
| columns / column [1..N] | Column constraint and foreign key information. Setting the "defaultValue" attribute will specify a default value for the column. Setting the "value" attribute will set all rows existing to the specified value without modifying the column default.Note: columns tag not required in XML See the column tag documentation for more information |
<changeSet author="liquibase-docs" id="addColumn-example">
<addColumn catalogName="cat"
schemaName="public"
tableName="person">
<column name="address"
position="2"
type="varchar(255)"/>
<column afterColumn="id"
name="name"
type="varchar(50)">
<constraints nullable="false"/>
</column>
</addColumn>
</changeSet>changeSet:
id: addColumn-example
author: liquibase-docs
changes:
- addColumn:
catalogName: cat
columns:
- column:
name: address
position: 2
type: varchar(255)
- column:
afterColumn: id
constraints:
nullable: false
name: name
type: varchar(50)
schemaName: public
tableName: person{
"changeSet": {
"id": "addColumn-example",
"author": "liquibase-docs",
"changes": [
{
"addColumn": {
"catalogName": "cat",
"columns": [
{
"column": {
"name": "address",
"position": 2,
"type": "varchar(255)"
}
},
{
"column": {
"afterColumn": "id",
"constraints": {
"nullable": false
},
"name": "name",
"type": "varchar(50)"
}
}]
,
"schemaName": "public",
"tableName": "person"
}
}]
}
}SQL Generated From Above Sample (MySQL)
ALTER TABLE cat.person ADD address VARCHAR(255) NULL,
ADD name VARCHAR(50) NOT NULL AFTER `id`;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 |