method

index_exists?

v3.0.0 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::SchemaStatements

index_exists?(table_name, column_name, options = {}) public

Checks to see if an index exists on a table for a given index definition

Examples

 # Check an index exists
 index_exists?(:suppliers, :company_id)

 # Check an index on multiple columns exists
 index_exists?(:suppliers, [:company_id, :company_type])

 # Check a unique index exists
 index_exists?(:suppliers, :company_id, :unique => true)

 # Check an index with a custom name exists
 index_exists?(:suppliers, :company_id, :name => "idx_company_id"

Show source

# File activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 41
      def index_exists?(table_name, column_name, options = {})
        column_names = Array.wrap(column_name)
        index_name = options.key?(:name) ? options[:name].to_s : index_name(table_name, :column => column_names)
        if options[:unique]
          indexes(table_name).any?{ |i| i.unique && i.name == index_name }
        else
          indexes(table_name).any?{ |i| i.name == index_name }
        end
      end

index_exists?

Related methods

Examples