Re: How do I view PK and FK Constraints?
From: Kenneth Ho <kenho_at_hk.super.net>
Date: Wed, 30 Nov 1994 13:17:15 GMT
Message-ID: <kenho.154.2EDC7B5A_at_hk.super.net>
Date: Wed, 30 Nov 1994 13:17:15 GMT
Message-ID: <kenho.154.2EDC7B5A_at_hk.super.net>
In article <Roberts_D-281194082234_at_riversend.bms.com> Roberts_D_at_MSMAIL.BMS.COM (Dan Roberts) writes:
>After I have created a table in my Oracle database..How can I view which
>attributes I have assigned as Primary Keys and such. When I do a describe
>either tablename or catalog I really don't get the output I am looking
>for..Thanks.>>Dan
Try:
SELECT * FROM all_constraints WHERE table_name = <your table name>
>--
>Dan Roberts
>BRISTOL-MYERS SQUIBB PHARM. RES. CENTER "Nature is last at Bats"
>PRINCETON, NEW JERSEY U.S.A. PLANET EARTH, MILKY-WAY GALAXY
><<<<INTERNET ADDRESS>>>>Roberts_D_at_MSMAIL.BMS.COM
Received on Wed Nov 30 1994 - 14:17:15 CET