Maintaining Foreign Key Integrity - Database Engine 20 - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-07-02
dita:mapPath
qay1747160677197.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

Vantage verifies that the structure of columns defined as foreign keys, or referenced by foreign keys, is not changed in any manner that violates the rules for the definition of a foreign key constraint.

An ALTER TABLE (or DROP INDEX) request attempting to change the structure of such a column aborts and causes the system to return an error to the requestor.

Vantage verifies that a table referenced by another is not dropped. Before dropping the table, you must perform an ALTER TABLE request to drop the foreign key reference.