Change types

Change types available in Liquibase changelogs.

In this section

• Entities

  • AddAutoIncrement

  • AddColumn

  • AlterSequence

  • CreateFunction

  • CreateIndex

  • CreatePackage

  • CreatePackageBody

  • CreateProcedure

  • CreateSequence

  • CreateSynonym

  • CreateTable

  • CreateTrigger

  • CreateView

  • DisableTrigger

  • DropColumn

  • DropFunction

  • DropIndex

  • DropPackage

  • DropPackageBody

  • DropProcedure

  • DropSequence

  • DropSynonym

  • DropTable

  • DropTrigger

  • DropView

  • EnableTrigger

  • RenameColumn

  • RenameSequence

  • RenameTable

  • RenameTrigger

  • RenameView

  • SetColumnRemarks

  • SetTableRemarks

• Constraints

  • AddCheckConstraint

  • AddDefaultValue

  • AddForeignKeyConstraint

  • AddNotNullConstraint

  • AddPrimaryKey

  • AddUniqueConstraint

  • DisableCheckConstraint

  • DropAllForeignKeyConstraints

  • DropCheckConstraint

  • DropDefaultValue

  • DropForeignKeyConstraint

  • DropNotNullConstraint

  • DropPrimaryKey

  • DropUniqueConstraint

  • EnableCheckConstraint

• Data

  • AddLookupTable

  • Delete

  • Insert

  • LoadData

  • LoadUpdateData

  • MergeColumns

  • ModifyDataType

  • ModifySql

  • Update

• Miscellaneous

  • CustomChange

  • ExecuteCommand

  • MarkUnused

  • Output

  • RemoveChangeSetProperty

  • Sql

  • EndDelimiterSQLattribute

  • SqlFile

  • Stop

  • TagDatabase

• Nested tags

  • Column

• Amazon DynamoDB

  • CreateDynamoTable

  • CreateGlobalSecondaryIndex

  • DeleteDynamoTable

  • DeleteGlobalSecondaryIndex

  • Partiql

  • PartiqlFile

  • UpdateDynamoTable

  • UpdateGlobalSecondaryIndex

  • UpdateTableProvisionedThroughput

• Databricks

  • AlterCluster

  • AlterTableProperties

  • AlterViewProperties

  • AlterVolume

  • AnalyzeTable

  • CloneTable

  • CreateView

  • CreateVolume

  • CreateTable

  • ExtendedTableProperties

  • DropVolume

  • OptimizeTable

  • SyncIdentityColumn

  • VacuumTable

• MongoDB

  • Mongo

  • MongoFile

  • AdminCommand

  • CreateCollection

  • CreateIndex

  • DropCollection

  • DropIndex

  • InsertMany

  • InsertOne

  • RunCommand

• PostgreSQL

  • AlterCompositeTypeAttributes

  • AddAttribute

  • AlterAttribute

  • DropAttribute

  • ChangeCompositeTypeOwner

  • ChangeCompositeTypeSchema

  • CreateCompositeType

  • TypeAttribute

  • DropCompositeType

  • RenameCompositeType

  • RenameCompositeTypeAttribute

  • RenameViewColumn

  • RenameViewColumnsAndUpdateBody

• Snowflake

  • AbortWarehouseQueries

  • AddRowAccessPolicyOnTable

  • AddRowAccessPolicyOnView

  • AddStandardTableColumn

  • AlterDatabaseProperties

  • AlterDatabaseReplication

  • AlterDatabaseTags

  • Alter dynamic table - overview

  • Alter dynamic table - clustering

  • Alter dynamic table - collation

  • Alter dynamic table - column

  • Alter dynamic table - comment

  • Alter dynamic table - data retention

  • Alter dynamic table - immutable WHERE

  • Alter dynamic table - log level

  • Alter dynamic table - state

  • Alter dynamic table - tags

  • Alter dynamic table - target lag

  • Alter dynamic table - warehouse

  • Alter dynamic table - policies

  • Alter dynamic table - rename

  • Alter dynamic table - swap

  • AlterFileFormat

  • AlterMaterializedViewClustering

  • AlterMaterializedViewContacts

  • AlterMaterializedViewMaintenance

  • AlterMaterializedViewProperties

  • AlterMaterializedViewTags

  • AlterRoleComment

  • AlterRoleTags

  • AlterRowAccessPolicyBody

  • AlterRowAccessPolicyComment

  • AlterRowAccessPolicyTags

  • AlterSchemaContacts

  • AlterSchemaManagedAccess

  • AlterSchemaProperties

  • AlterSchemaTags

  • AlterSequence

  • AlterSequenceComment

  • AlterShareAccounts

  • AlterShareComment

  • AlterShareTags

  • AlterStageComment

  • AlterStageDirectoryTable

  • AlterStageFileFormat

  • AlterStageParams

  • AlterStageTags

  • Alter standard table - overview

  • Alter standard table - change tracking

  • Alter standard table - clustering

  • Alter standard table - collation

  • Alter standard table - column

  • Alter standard table - comment

  • Alter standard table - contacts

  • Alter standard table - data metrics

  • Alter standard table - data retention

  • Alter standard table - schema evolution

  • Alter standard table - search optimization

  • Alter standard table - tags

  • Alter standard table - policies

  • Alter standard table - rename

  • Alter standard table - swap

  • AlterStreamComment

  • AlterStreamTags

  • AlterTask

  • AlterViewProperties

  • AlterWarehouseProperties

  • AlterWarehouseState

  • AlterWarehouseTags

  • BulkGrantPrivilegeToShare

  • BulkRevokePrivilegeFromShare

  • CloneDatabase

  • CloneDynamicTable

  • CloneSchema

  • CloneTable

  • ColumnStandardTable

  • CreateDatabase

  • CreateDatabaseFromShare

  • CreateFileFormat

  • CreateMaterializedView

  • CreateRole

  • CreateRowAccessPolicy

  • CreateSchema

  • CreateSequence

  • CreateShare

  • CreateStage

  • CreateStream

  • CreateTable with dynamicTable

  • CreateTable with standardTable

  • CreateTask

  • CreateView

  • CreateWarehouse

  • DropDatabase

  • DropFileFormat

  • DropMaterializedView

  • DropRole

  • DropRowAccessPolicy

  • DropRowAccessPolicyOnTable

  • DropRowAccessPolicyOnView

  • DropSchema

  • DropSequence

  • DropShare

  • DropStage

  • DropStream

  • DropTask

  • DropView

  • DropWarehouse

  • ExecuteTask

  • GrantPrivilegeToShare

  • GrantRole

  • RenameDatabase

  • RenameFileFormat

  • RenameMaterializedView

  • RenameRole

  • RenameRowAccessPolicy

  • RenameSchema

  • RenameSequence

  • RenameStage

  • RenameView

  • RenameWarehouse

  • RevokePrivilegeFromShare

  • RevokeRole

  • SwapDatabase

  • SwapSchema

  • UndropDatabase

  • UndropSchema

  • UseWarehouse

• Teradata

  • BteqExport

  • BteqImport

  • BteqInsert

  • BteqMacro

• What is a change type?