method

index_exists?

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

1.0.0
1.1.0
1.1.1
1.1.6
1.2.0
1.2.6
2.0.0
2.0.1
2.0.3
2.1.0
2.2.1
2.3.2
2.3.8 (0)
3.0.0 (38)
3.0.5 (0)
3.0.7 (0)
3.0.9 (-4)
3.1.0 (0)
3.2.1 (0)
3.2.3 (0)
3.2.8 (0)
3.2.13 (0)
What's this?

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

Flowdock - Team Inbox With Chat