The following table compares the three referential integrity constraint types supported by Vantage.
| Referential Constraint Type | DDL Definition Clause | Does It Enforce Referential Integrity? | Level of Enforcement |
|---|---|---|---|
| Standard | REFERENCES | Yes | Single row |
| Batch | REFERENCES WITH CHECK OPTION | Yes | All child table rows must match a parent table row. |
The different types have different applications, as the following table documents.
| Referential Constraint Type | Application |
|---|---|
| Standard |
|
| Batch |
|