Referential Integrity in SQL

• When creating table we specify primary , candidate and foreign keys. These are specifying referential integrity.

• Example Fig6.2

Create table depositor

(cname char(20) not null,

acctNo char(10) not null,

primary key (cname, acctNo),

foreign key (cname) references customer,

foreign key (acctNo) references account)

Previous slide

Next slide

Back to first slide

View graphic version