Maintaining Foreign Key Integrity - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

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 trying 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.