method

remove_unique_constraint

v7.2.3 - Show latest stable - Class: ActiveRecord::ConnectionAdapters::PostgreSQL::SchemaStatements

remove_unique_constraint(table_name, column_name = nil, **options)

public

Removes the given unique constraint from the table.

remove_unique_constraint :sections, name: "unique_position"

The column_name parameter will be ignored if present. It can be helpful to provide this in a migration’s change method so it can be reverted. In that case, column_name will be used by #add_unique_constraint.

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 777
        def remove_unique_constraint(table_name, column_name = nil, **options)
          unique_name_to_delete = unique_constraint_for!(table_name, column: column_name, **options).name

          at = create_alter_table(table_name)
          at.drop_unique_constraint(unique_name_to_delete)

          execute schema_creation.accept(at)
        end

remove_unique_constraint

Related methods