ALTER TABLE XXX
ADD CONSTRAINT R_374 FOREIGN KEY (QuarterPeriodNum) REFERENCES WITH NO CHECK OPTION YYY (QuarterPeriodNum)
[Teradata][ODBC Teradata Driver][Teradata Database] Incorrect referential constraint definition.
ALTER TABLE Failed. 3976: Incorrect referential constraint definition.
Can some body help me why I am getting this error.
Can you please share the parent table definition as well. As the error might be due to the definition of QuarterPeriodNum column.
This column must be defined as UNIQUE and NOT NULL in order to be referenced.