v7.1.3.2 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::SchemaStatements
add_check_constraint(table_name, expression, if_not_exists: false, **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"


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

The options hash can include the following keys:


The constraint name. Defaults to chk_rails_<identifier>.


Silently ignore if the constraint already exists, rather than raise an error.


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

Show source
Register or log in to add new notes.