The following table defines the Referential Integrity terminology that CheckTable uses.
Term | Definition |
---|---|
Primary Key | One or more columns that uniquely identify a table row. |
Foreign Key | One or more columns in a table (the child table) that references the Primary Key in one or more tables (the parent tables). |
Parent Table | Table having a Primary Key that is referenced by another table, the child table. |
Child Table | Table having a Foreign Key that references the Primary Key in another table, the parent table. |
For more information on referential integrity, see Teradata Vantage™ - SQL Fundamentals, B035-1141 and Teradata Vantage™ - Database Design, B035-1094.