Re: Help! defining referential integrity

From: TurkBear <jvgreco_at_pop.primenet.com>
Date: 1997/10/24
Message-ID: <3450fa6d.12197128@news.primenet.com>#1/1

earvin_at_omega.uta.edu (Earvin C. Lim) wrote:

>
>Hi there!
>
>I have the following questions and hope someone would help me:
>
>When we create tables, how do we define referential integrities?
>
>thanks in advance!
>--
>Earvin Lim
>-- Programmer/Analyst
>-- Academic Computing Services
>-- University of Texas at Arlington
>email: elim_at_uta.edu
>Phone: (817)272-3678

Create the master table ( the one with the primary key ) Create the referencing table(s) and define foreign keys to refer to the master.

See the Manuals for a detailed explanation of primary and foreign keys.

Hope it helps,
John Greco Received on Fri Oct 24 1997 - 00:00:00 CDT