Adding FOREIGN KEY to a table in Teradata

You can add referential constraints also using ALTER command.

Syntax:
ALTER TABLE tbl_name_this ADD FOREIGN KEY (column_this_table) REFERENCES tbl_name_that (column_that_table)

Example:
ALTER TABLE tbl_emp ADD FOREIGN KEY (DeptNo) REFERENCES tbl_dept(department_number)