| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Can ref_int be defined with standard SQL at all?
Can anybody please let me know how to set up referential integrity using standard SQL - I don't want to deal with tricks like MS SQL Server 7.X triggers...
So, the bottom line question is: What are the standard SQL statements
to
make ref. int. between e.g. the following two relations (Customer_ID is
a foreign key in the second table):
(#Customer_ID, Name, Surname) and (#Item_ID, #Customer_ID, Quantity).
Thank you for your answer in advance. D. Trcek Received on Tue Jan 16 2001 - 03:22:13 CST
![]() |
![]() |