/ Ruby on Rails
/
method

remove_check_constraints

rails latest stable - Class: ActiveRecord::ConnectionAdapters::SQLServerAdapter

Method deprecated or moved

This method is deprecated or moved on the latest stable version. The last existing version (v1.2.6) is shown here.

remove_check_constraints(table_name, column_name)
public

No documentation available.

# File activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb, line 485
      def remove_check_constraints(table_name, column_name)
        # TODO remove all constraints in single method
        constraints = select "SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = '#{table_name}' and COLUMN_NAME = '#{column_name}'"
        constraints.each do |constraint|
          execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint["CONSTRAINT_NAME"]}"
        end
      end