addColumn

<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>

databaseChangeLog:
  - changeSet:
      id: addColumn-example
      author: liquibase-docs
      changes:
        - addColumn:
            tableName: person
            columns:
            - column:
                name: middlename
                type: varchar(50)

{
  "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"
          }
        }
      ]
    }
  }

ALTER TABLE cat.person ADD address VARCHAR(255) NULL,  
ADD name VARCHAR(50) NOT NULL AFTER `id`;

The <column> tag is a tag that is re-used throughout the Liquibase XML when column definitions and column information is needed. As a result, not all the attributes of column are valid in each context it is used in.

Available attributes

To help make scripts database-independent, the following generic data types will be converted to the correct database implementation:

• BOOLEAN
• CURRENCY
• UUID
• CLOB
• BLOB
• DATE
• DATETIME
• TIME
• BIGINT

Also, specifying a java.sql.Types.* type will be converted to the correct type as well. See the following examples:

• java.sql.Types.TIMESTAMP
• java.sql.Types.VARCHAR(255)

Available sub-tags

Constraints tag

The <constraints> tag contains information about constraints on the column.

Available attributes