Re: How to view table constraint?

From: John Chiu <johnymc_at_netscape.net>
Date: Thu, 28 Oct 1999 06:33:23 -0400
Message-ID: <7v98pi$q8q$1@news2.tor.accglobal.net>

You can use (DBA/ALL/) USER_CONSTRAINTS and (DBA/ALL/) USER_CONS_COLUMNS views to check the table constraints

John Chiu
OCP DBA (7.3 & 8) Jeff Lee <kit_at_cintec.cuhk.edu.hk> wrote in message news:7v8pjq$ot9$1_at_justice.csc.cuhk.edu.hk...
> Hello,
>
> Do you know how to view constraints of a table?
>
> Jeff
>
>
Received on Thu Oct 28 1999 - 05:33:23 CDT

This message: [ Message body ]
Next message: jason: "HTML -> Oracle Procedure question"
Previous message: Frank van Bortel: "Re: Need help on character set selection!"
In reply to: Jeff Lee: "How to view table constraint?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US