Constraint

• primary key
• foreign key
• unique
• check
• not null

on delete cascase
on update cascade
on delete set null
on delete set default

Drop

alter table table_name drop constraint constraint_name

Assertion

create assertion name check predicate

GENERATE

domain