Establish Referential Intergrity Constraint in SQL

 

Question:

Establish Referential Intergrity Constraint

Identify the common key between the two tables given below and establish referential integrity constraint between them.

CODE:

alter table PointofInterest add constraint FK foreign key (townID) references Town(townID);

Tags:

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program
Previous
Next Post »