Re: ci_ views

Originally posted by Iain Brown

> Hi,

>

> I've been given the lovely task of documenting the contents of my
> project's

> database tables.

>

> I got told to use report generator with the ci_ views, e.g.

> ci_table_definition, ci_primary_key_constraints... etc.

>

> Anyway, I managed to get what I needed for the table itself, but
> for the key

> constraints, I cannot find how the ci_ views link the keys to
> their fields.

> E.g. a primary key called 'MME_PRK' was made up of 3 fields. Yet the

> ci_primary_key_constraints view contained 10 records with the name
> MME_PRK',

> all identical except the IVID and PARENT_IVID fields - which are
> the version

> id's. I didn't find anything obvious in the ci_columns view either.

>

> I'm using Oracle 9i

>

> Hope you can help,

>

> Iain

These CI_ views are part of Oracle Designer, they are not part of the Oracle server's data dictionary. I am not familiar with the latest version of Designer, but I know it has a new versioning system of some sort. Anyway, a primary key constrant will only have 1 (current) record in ci_primary_key_constraints, and the 3 columns that comprise the key will be found in ci_key_components (again, many times presumably, if there have been several versions).

--
Posted via http://dbforums.com