Type | Keyword | Example |
Referential | REFERENCES | ALTER TABLE dept_const ADD CONSTRAINT chkmgr FOREIGN KEY(mgr) REFERENCES emp(ename); |
Unique | UNIQUE | ALTER TABLE emp_const ADD UNIQUE (eno, ename); |
Primary key | PRIMARY KEY | ALTER TABLE emp_const ADD CONSTRAINT ekey PRIMARY KEY(eno); |