Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I know what constraints are ?
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