Hi Ivan!

See below structure of some Oracle views:

All_Constraints
---------------
OWNER
CONSTRAINT_NAME
CONSTRAINT_TYPE (P=PK, R=FK, C=Constraint)
TABLE_NAME
SEARCH_CONDITION (Constraints)

R_OWNER (Owner PK)
R_CONSTRAINT_NAME (Table PK)


-------------------------------------------------
All_Cons_Columns
________________

OWNER
CONSTRAINT_NAME
TABLE_NAME
COLUMN_NAME
POSITION (PK & FK)


-------------------------------------------------
COLS
____

OWNER
TABLE_NAME
FIELD_NAME
FIELD_NUMBER
FIELD_TYPE
WIDTH
SCALE
PRECISION
NULLS
DEFAULT_VALUE
--------------------------------------------------


Cicero

--- In firebird-support@yahoogroups.com, Ivan Cruz <ivan@a...> wrote:
> cicerobillo wrote:
>
> >This is ok, but what about Check Constraints?
> >
> >TIA
> >
> >Cicero
> >
> >
> >
> >
> I'm not a Oracle user so, what I get in a All_Constraints view
> and in a Users_Constraints view?
>
> Ivan.