Copy to clipboard

dropUniqueConstraint

Drops an existing unique constraint.

Note: For OracleDB, the index associated with the constraint is also dropped.

To run this Change Type, follow these steps:

Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the update command:liquibase update

Name	Description	Required for	Supports	Since
`catalogName`	Name of the catalog		all	3.0
`constraintName`	Name of the constraint	all	all
`schemaName`	Name of the schema		all
`tableName`	Name of the table to drop the unique constraint from	all	all
`uniqueColumns`	For SAP SQL Anywhere, a list of columns in the UNIQUE clause		sybase

--liquibase formatted sql
--changeset liquibase-docs:dropUniqueConstraint-example
ALTER TABLE cat.person
DROP KEY const_name;

--liquibase formatted sql
--changeset liquibase-docs:dropUniqueConstraint-example
ALTER TABLE cat.person
DROP KEY const_name;