Re: How can I know what constraints are ?

From: ktlim <ktlim_at_lgtel.co.kr>
Date: Thu, 07 May 1998 17:38:23 +0900
Message-ID: <355172FF.60332BB1@lgtel.co.kr>

Jordi Bellver wrote:

> Hi !
>
> I'ld like to know what ar the constraints declared for a table (or all
>
> tables) and the status (enable/disable) of all them.
>
> What must I do ?
>
> Thanks in advance !
>
> (sorry for my poor level of english)

hi!
check USER_CONSTRAINTS, USER_CONS_COLUMNS views. that is oracle dictionary view.

bye. Received on Thu May 07 1998 - 03:38:23 CDT

This message: [ Message body ]
Next message: Ian: "Bytes per record?"
Previous message: ktlim: "[Q] about oracle reorganization tool."
In reply to: Jordi Bellver: "How can I know what constraints are ?"
Next in thread: chajec_at_nspr.com: "Re: How can I know what constraints are ?"
Reply: chajec_at_nspr.com: "Re: How can I know what constraints are ?"

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