Foreign key referencing of two DB2 tables

A foreign key is a column in a table that establishes a referential link with another table. A foreign key can be defined during creation of table (CREATE TABLE command) or it can be defined by modifying the table (ALTER TABLE command). However, before defining any key as foreign key, make sure that an index is built up on that column. We can use the below command to define an existing column CLASS in table TAB1 as a foriegn key which links to table TAB2.

ALTER TABLE TAB1
ADD FOREIGN KEY (CLASS) REFERENCES CLASSDATA (CLASS_ID);

The ALTER TABLE reserved words are followed by the name of the table which has to be modified.

Then we will use the ADD FOREIGN KEY parameter to define the name of the column which has to be defined as foreign key. Which is CLASS in this case.

At last we have to use a REFERENCES reserved word followed by the name of the database and corresponding column name which needs to be linked.

Mandalika

Published on 12-Sep-2020 13:18:09

• Related Questions & Answers
• What is CASCADE rule for the foreign key on one table referencing to another table?
• Foreign Key in RDBMS
• In case of FOREIGN KEY constraint, what kind of relationship is there between MySQL parent and child tables?
• MySQL Syntax to create Foreign Key?
• Difference between Primary key and Foreign key in Database
• Difference Between Primary key and Foreign key in DBMS
• Get a list of Foreign Key constraints in MySQL
• When are two tables connected with MySQL FOREIGN KEY then how can we say that the integrity of data is maintained in child table?
• Difference between Primary key and Foreign key in SQL Database
• How to find all the foreign keys of a DB2 table TAB1?
• How to identify foreign key in MySQL DB?
• MySQL join two tables?
• How can we assign FOREIGN KEY constraint on multiple columns?
• How to find the primary key of a DB2 table TAB1?
• Verify that MySQL SET FOREIGN KEY CHECKS is set to = 1?