Semantic Integrity | Database Design | VantageCloud Lake - Semantic Integrity Constraint Types - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Constraints are only supported on the Block File System on the primary cluster. They are not available for the Object File System.
Business rules are expressed in relational databases by using integrity constraints. Four types of integrity constraint are supported:
  • Domain
  • Column
  • Table
  • Database

These four types of constraints are implemented in distinct ways, though the differences between column and table constraints are subtle.