Flowdock
method

add_check_constraint

Importance_1
v6.1.3.1 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::SchemaStatements
add_check_constraint(table_name, expression, **options) public

Adds a new check constraint to the table. expression is a String representation of verifiable boolean condition.

add_check_constraint :products, "price > 0", name: "price_check"

generates:

ALTER TABLE "products" ADD CONSTRAINT price_check CHECK (price > 0)

The options hash can include the following keys:

:name

The constraint name. Defaults to chk_rails_<identifier>.

:validate

(PostgreSQL only) Specify whether or not the constraint should be validated. Defaults to true.

Show source
Register or log in to add new notes.