check function

CheckBuilder check(
  1. String name,
  2. Filter predicate
)

A table-level CHECK constraint.

final pets = table('pets', PetSchema.new, (table) {
  check('pets_legs', table.legs.greaterThan(0)).on(table);
});

For what the DSL cannot say, the predicate can be a raw() fragment:

check('one_ref', raw('("a" IS NOT NULL) + ("b" IS NOT NULL) = 1')).on(t);

Implementation

CheckBuilder check(String name, Filter predicate) =>
    CheckBuilder(name, predicate);