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 »

ConversionConversion EmoticonEmoticon

:)
:(
=(
^_^
:D
=D
=)D
|o|
@@,
;)
:-bd
:-d
:p
:ng