Teradata Alter Table Add Foreign Key
The RazorSQL alter table tool includes an Add Foreign Key option for adding foreign keys to Teradata database tables. The add foreign key function lists all of the columns of the table and allows the user to choose one or more columns to add to the foreign key for the table. It also lists the other tables available on the database so that the user can choose a referenced table and referenced column or columns.
Listed below is an example of the SQL generated by the Teradata Alter Table Add Foreign Key function:
ALTER TABLE RETAIL.EMPLOYEE
ADD FOREIGN KEY (DeptNo)
REFERENCES retail.CLIENT(C_CUSTKEY)
Below is a screen shot of the add foreign key function of the Teradata alter table tool.
