Home -> Usenet -> comp.databases.oracle -> Re: constraints and foreign keys

Re: constraints and foreign keys

From: Frenchy461 <frenchy461_at_aol.com>
Date: 1996/09/05
Message-ID: <50m3h2$kkh_at_newsbf02.news.aol.com>#1/1 








User_constraints


   Foreign Key Record (Table -> Order_items)


        constraint_name = FK_orditm_order_num(pointing to
Orders->order_num)

        r_constraint_name = PK_orders_order_num --
   Primary Key Record (Table -> Orders)                | Same constraint
name
       constraint_name = PK_orders_order_num ------
       r_constraint_name IS NULL


Received on Thu Sep 05 1996 - 00:00:00 CEST












Original text of this message