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

• Tweet
• Share
• Share
• Share
• Share

Related Post

• Update Schedule table in SQLQuestion:Update Schedule tableContains the run and evaluate script of Oracle DML. Can be used as ex
• Update Buses table in SQLQuestion:Update Buses tableContains the run and evaluate script of Oracle DML. Can be used as examp
• Create SCHEDULE table program in SQL Question:Create SCHEDULE tableRefer the below schema and create the SCHEDULE.Column NameDatat
• Insert Records into Resort table in SQLQuestion:Insert Records into Resort tableInsert the following records into “Resort ” table based on