columnStandardTable

Last updated: January 27, 2026

Nested element for defining columns within createStandardTable.

This is a separate element from Liquibase column - it uses its own XSD definition to include Snowflake-specific features while excluding unsupported core attributes.

Supported attributes

From core column

Attribute	Type	Description
`name`	String	Column name (required)
`type`	String	Snowflake data type
`nullable`	Boolean	Whether column allows NULL (default: true)
`computed`	Boolean	Whether value is computed
`remarks`	String	Column comment
`defaultValue`	String	Default string value
`defaultValueNumeric`	String	Default numeric value
`defaultValueBoolean`	Boolean	Default boolean value
`defaultValueDate`	String	Default date value (ISO format)
`defaultValueComputed`	String	Default computed expression
`defaultValueSequenceNext`	String	Sequence NEXTVAL as default
`defaultValueSequenceCurrent`	String	Sequence CURRVAL as default
`defaultValueConstraintName`	String	Name for default value constraint
`autoIncrement`	Boolean	Enable autoincrement
`startWith`	Long	Starting value for autoincrement
`incrementBy`	Long	Increment step for autoincrement
`generationType`	String	Generation type for auto-increment
`defaultOnNull`	Boolean	Generate value when NULL is inserted

Snowflake-specific

Attribute	Type	Description
`autoIncrementOrder`	String	Sequence ordering: `ORDER` or `NOORDER`*
`collation`	String	Column collation (e.g., `en-ci`)
`maskingPolicy`	String	Name of masking policy to apply
`maskingPolicyUsing`	String	Columns for USING clause in masking policy
`projectionPolicy`	String	Name of projection policy to apply

*Only valid when autoIncrement=true.

ORDER vs NOORDER behavior

Mode	Guarantees	Performance	Use case
`ORDER`	Values in strict sequential order	Reduced concurrency	Invoice numbers, audit sequences
`NOORDER`	Unique values, may have gaps	Better throughput	Log entries, event records

Unsupported core attributes

These core column attributes are not available:

Attribute	Reason
`afterColumn`	Snowflake doesn't support column positioning
`beforeColumn`	Snowflake doesn't support column positioning
`position`	Snowflake doesn't support column positioning
`value`	Use `defaultValue` instead (for table creation)
`valueNumeric`	Use `defaultValueNumeric` instead
`valueBoolean`	Use `defaultValueBoolean` instead
`valueDate`	Use `defaultValueDate` instead
`valueComputed`	Use `defaultValueComputed` instead
`valueBlobFile`	Not supported in table creation context
`valueClobFile`	Not supported in table creation context
`encoding`	Not applicable
`descending`	Not applicable (index-specific)

Nested elements

constraints

Extends core constraints with Snowflake-specific options.

Attribute	Type	Description
`enforced`	Boolean	Whether constraint is enforced (Snowflake-specific)
`rely`	Boolean	Whether optimizer relies on constraint (Snowflake-specific)
`onUpdateAction`	String	Foreign key update action: `CASCADE`, `RESTRICT`, etc.
`onDeleteAction`	String	Foreign key delete action: `CASCADE`, `SET NULL`, `SET DEFAULT`

tags

Column-level tags for metadata management (nested element in XML, array in JSON/YAML).

--liquibase formatted sql

--changeset examples:standard-table-with-order-column
-- Standard table with ORDER column
CREATE TABLE PUBLIC.ORDERS_WITH_ORDERED_ID (
    ID NUMBER AUTOINCREMENT ORDER START 1 INCREMENT 1 PRIMARY KEY,
    ORDER_NUMBER VARCHAR(50) NOT NULL,
    AMOUNT NUMBER(10,2)
);

--changeset examples:standard-table-with-noorder-column
-- Standard table with NOORDER column
CREATE TABLE PUBLIC.LOGS_WITH_NOORDER_ID (
    LOG_ID NUMBER AUTOINCREMENT NOORDER START 1 INCREMENT 1,
    MESSAGE VARCHAR(500),
    CREATED_AT TIMESTAMP_NTZ
);

--changeset examples:mixed-column-types-with-custom-sequence
-- Mixed column types with custom sequence
CREATE TABLE PUBLIC.MIXED_COLUMN_TYPES (
    ID NUMBER AUTOINCREMENT ORDER START 1000 INCREMENT 10 PRIMARY KEY,
    NAME VARCHAR(100) NOT NULL,
    VERSION NUMBER AUTOINCREMENT NOORDER START 1 INCREMENT 1
);

<pro-snowflake:createStandardTable tableName="USER_PROFILES">

    <!-- Autoincrement with ORDER for sequential IDs -->
    <pro-snowflake:columnStandardTable
            name="user_id"
            type="NUMBER(38,0)"
            autoIncrement="true"
            startWith="1"
            incrementBy="1"
            autoIncrementOrder="ORDER"
            nullable="false">
        <pro-snowflake:constraints
                primaryKey="true"
                primaryKeyName="pk_user_profiles"
                enforced="true"
                rely="true"/>
    </pro-snowflake:columnStandardTable>

    <!-- Autoincrement with NOORDER for high concurrency -->
    <pro-snowflake:columnStandardTable
            name="session_id"
            type="NUMBER(38,0)"
            autoIncrement="true"
            startWith="1000"
            incrementBy="1"
            autoIncrementOrder="NOORDER"
            nullable="false">
        <pro-snowflake:constraints
                unique="true"
                enforced="false"
                rely="true"/>
    </pro-snowflake:columnStandardTable>

    <!-- Column with masking policy -->
    <pro-snowflake:columnStandardTable
            name="email"
            type="VARCHAR(200)"
            maskingPolicy="email_mask"
            nullable="false">
        <pro-snowflake:constraints
                unique="true"
                enforced="true"
                rely="true"/>
        <pro-snowflake:tags>
            <pro-snowflake:entry key="pii" value="email"/>
        </pro-snowflake:tags>
    </pro-snowflake:columnStandardTable>

    <!-- Column with collation -->
    <pro-snowflake:columnStandardTable
            name="username"
            type="VARCHAR(50)"
            collation="en-ci"
            nullable="false"/>

    <!-- Column with projection policy -->
    <pro-snowflake:columnStandardTable
            name="account_balance"
            type="NUMBER(18,2)"
            defaultValueNumeric="0.00"
            projectionPolicy="sensitive_data_projection"
            nullable="false"/>

</pro-snowflake:createStandardTable>

{
  "createStandardTable": {
    "tableName": "USER_PROFILES",
    "columns": [
      {
        "column": {
          "name": "user_id",
          "type": "NUMBER(38,0)",
          "autoIncrement": true,
          "startWith": 1,
          "incrementBy": 1,
          "autoIncrementOrder": "ORDER",
          "nullable": false,
          "constraints": {
            "primaryKey": true,
            "primaryKeyName": "pk_user_profiles",
            "enforced": true,
            "rely": true
          }
        }
      },
      {
        "column": {
          "name": "session_id",
          "type": "NUMBER(38,0)",
          "autoIncrement": true,
          "startWith": 1000,
          "incrementBy": 1,
          "autoIncrementOrder": "NOORDER",
          "nullable": false,
          "constraints": {
            "unique": true,
            "enforced": false,
            "rely": true
          }
        }
      },
      {
        "column": {
          "name": "email",
          "type": "VARCHAR(200)",
          "maskingPolicy": "email_mask",
          "nullable": false,
          "constraints": {
            "unique": true,
            "enforced": true,
            "rely": true
          },
          "tags": [
            {"entry": {"key": "pii", "value": "email"}}
          ]
        }
      },
      {
        "column": {
          "name": "username",
          "type": "VARCHAR(50)",
          "collation": "en-ci",
          "nullable": false
        }
      },
      {
        "column": {
          "name": "account_balance",
          "type": "NUMBER(18,2)",
          "defaultValueNumeric": "0.00",
          "projectionPolicy": "sensitive_data_projection",
          "nullable": false
        }
      }
    ]
  }
}

createStandardTable:
  tableName: USER_PROFILES
  columns:
    - column:
        name: user_id
        type: NUMBER(38,0)
        autoIncrement: true
        startWith: 1
        incrementBy: 1
        autoIncrementOrder: ORDER
        nullable: false
        constraints:
          primaryKey: true
          primaryKeyName: pk_user_profiles
          enforced: true
          rely: true
    - column:
        name: session_id
        type: NUMBER(38,0)
        autoIncrement: true
        startWith: 1000
        incrementBy: 1
        autoIncrementOrder: NOORDER
        nullable: false
        constraints:
          unique: true
          enforced: false
          rely: true
    - column:
        name: email
        type: VARCHAR(200)
        maskingPolicy: email_mask
        nullable: false
        constraints:
          unique: true
          enforced: true
          rely: true
        tags:
          - entry:
              key: pii
              value: email
    - column:
        name: username
        type: VARCHAR(50)
        collation: en-ci
        nullable: false
    - column:
        name: account_balance
        type: NUMBER(18,2)
        defaultValueNumeric: '0.00'
        projectionPolicy: sensitive_data_projection
        nullable: false

--liquibase formatted sql

--changeset examples:standard-table-with-order-column
-- Standard table with ORDER column
CREATE TABLE PUBLIC.ORDERS_WITH_ORDERED_ID (
    ID NUMBER AUTOINCREMENT ORDER START 1 INCREMENT 1 PRIMARY KEY,
    ORDER_NUMBER VARCHAR(50) NOT NULL,
    AMOUNT NUMBER(10,2)
);

--changeset examples:standard-table-with-noorder-column
-- Standard table with NOORDER column
CREATE TABLE PUBLIC.LOGS_WITH_NOORDER_ID (
    LOG_ID NUMBER AUTOINCREMENT NOORDER START 1 INCREMENT 1,
    MESSAGE VARCHAR(500),
    CREATED_AT TIMESTAMP_NTZ
);

--changeset examples:mixed-column-types-with-custom-sequence
-- Mixed column types with custom sequence
CREATE TABLE PUBLIC.MIXED_COLUMN_TYPES (
    ID NUMBER AUTOINCREMENT ORDER START 1000 INCREMENT 10 PRIMARY KEY,
    NAME VARCHAR(100) NOT NULL,
    VERSION NUMBER AUTOINCREMENT NOORDER START 1 INCREMENT 1
);

<pro-snowflake:createStandardTable tableName="USER_PROFILES">

    <!-- Autoincrement with ORDER for sequential IDs -->
    <pro-snowflake:columnStandardTable
            name="user_id"
            type="NUMBER(38,0)"
            autoIncrement="true"
            startWith="1"
            incrementBy="1"
            autoIncrementOrder="ORDER"
            nullable="false">
        <pro-snowflake:constraints
                primaryKey="true"
                primaryKeyName="pk_user_profiles"
                enforced="true"
                rely="true"/>
    </pro-snowflake:columnStandardTable>

    <!-- Autoincrement with NOORDER for high concurrency -->
    <pro-snowflake:columnStandardTable
            name="session_id"
            type="NUMBER(38,0)"
            autoIncrement="true"
            startWith="1000"
            incrementBy="1"
            autoIncrementOrder="NOORDER"
            nullable="false">
        <pro-snowflake:constraints
                unique="true"
                enforced="false"
                rely="true"/>
    </pro-snowflake:columnStandardTable>

    <!-- Column with masking policy -->
    <pro-snowflake:columnStandardTable
            name="email"
            type="VARCHAR(200)"
            maskingPolicy="email_mask"
            nullable="false">
        <pro-snowflake:constraints
                unique="true"
                enforced="true"
                rely="true"/>
        <pro-snowflake:tags>
            <pro-snowflake:entry key="pii" value="email"/>
        </pro-snowflake:tags>
    </pro-snowflake:columnStandardTable>

    <!-- Column with collation -->
    <pro-snowflake:columnStandardTable
            name="username"
            type="VARCHAR(50)"
            collation="en-ci"
            nullable="false"/>

    <!-- Column with projection policy -->
    <pro-snowflake:columnStandardTable
            name="account_balance"
            type="NUMBER(18,2)"
            defaultValueNumeric="0.00"
            projectionPolicy="sensitive_data_projection"
            nullable="false"/>

</pro-snowflake:createStandardTable>

{
  "createStandardTable": {
    "tableName": "USER_PROFILES",
    "columns": [
      {
        "column": {
          "name": "user_id",
          "type": "NUMBER(38,0)",
          "autoIncrement": true,
          "startWith": 1,
          "incrementBy": 1,
          "autoIncrementOrder": "ORDER",
          "nullable": false,
          "constraints": {
            "primaryKey": true,
            "primaryKeyName": "pk_user_profiles",
            "enforced": true,
            "rely": true
          }
        }
      },
      {
        "column": {
          "name": "session_id",
          "type": "NUMBER(38,0)",
          "autoIncrement": true,
          "startWith": 1000,
          "incrementBy": 1,
          "autoIncrementOrder": "NOORDER",
          "nullable": false,
          "constraints": {
            "unique": true,
            "enforced": false,
            "rely": true
          }
        }
      },
      {
        "column": {
          "name": "email",
          "type": "VARCHAR(200)",
          "maskingPolicy": "email_mask",
          "nullable": false,
          "constraints": {
            "unique": true,
            "enforced": true,
            "rely": true
          },
          "tags": [
            {"entry": {"key": "pii", "value": "email"}}
          ]
        }
      },
      {
        "column": {
          "name": "username",
          "type": "VARCHAR(50)",
          "collation": "en-ci",
          "nullable": false
        }
      },
      {
        "column": {
          "name": "account_balance",
          "type": "NUMBER(18,2)",
          "defaultValueNumeric": "0.00",
          "projectionPolicy": "sensitive_data_projection",
          "nullable": false
        }
      }
    ]
  }
}

createStandardTable:
  tableName: USER_PROFILES
  columns:
    - column:
        name: user_id
        type: NUMBER(38,0)
        autoIncrement: true
        startWith: 1
        incrementBy: 1
        autoIncrementOrder: ORDER
        nullable: false
        constraints:
          primaryKey: true
          primaryKeyName: pk_user_profiles
          enforced: true
          rely: true
    - column:
        name: session_id
        type: NUMBER(38,0)
        autoIncrement: true
        startWith: 1000
        incrementBy: 1
        autoIncrementOrder: NOORDER
        nullable: false
        constraints:
          unique: true
          enforced: false
          rely: true
    - column:
        name: email
        type: VARCHAR(200)
        maskingPolicy: email_mask
        nullable: false
        constraints:
          unique: true
          enforced: true
          rely: true
        tags:
          - entry:
              key: pii
              value: email
    - column:
        name: username
        type: VARCHAR(50)
        collation: en-ci
        nullable: false
    - column:
        name: account_balance
        type: NUMBER(18,2)
        defaultValueNumeric: '0.00'
        projectionPolicy: sensitive_data_projection
        nullable: false