Re: table constraints

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Mon, 13 Sep 1999 13:05:54 -0400
Message-ID: <37dd2f28@defiant.btitelecom.net>

The user_constraints view will have the referenced constraint and referenced owner in the R_CONSTRAINT_NAME and R_OWNER fields. The type of constraint is in the CONSTRAINT_TYPE field and I believe you would be looking for a CONSTRAINT_TYPE of 'C'.

The columns of a constraint are in user_cons_columns in the COLUMN_NAME field. Hint: order your query by the POSITION field to determine the order the constraint columns are in...

delonte_at_my-deja.com wrote in message <7rj795$qod$1_at_nnrp1.deja.com>...
>Hello,
>
>I have been using the table user_constraints, to obtain information
>concerning constraints on tables. The information from this table is
>minimal and I am wondering if there is a table(*) which provides more
>detail. Is there a table(s) that contains the following constraint
>information?
>
> check condition
> referenced schema
> referenced table
> referenced column
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 12:05:54 CDT