Re: Question about designer

"�lvaro Palma Aste" <me_aburri_del_spam_at_kqk.com> wrote in message news:9t39f4$flo$2_at_news.cec.uchile.cl...
> Hi, I�m developing a little script that compare an application system in
> Designer v/s a database, so I can see the differences between them, in
tables.
> columns, sequences and constraints. By I still can retrieve the columns
> associated to a particular constraint in the Designer repository. I know
that
> the table CI_CONSTRAINT of the repository stores the description of the
> constraints in the model, and the table CI_COLUMNS stores the definitions
of
> the columns, but, what's is or are the table(s) which connect them?, I
mean,
> what table stores the relation between constraints and the columns in the
> model? In as normal database, this table is all_cons_columns, but I can�t
find
> its "partner" in the Repository.
>
> Thanks a lot for your answers
>
> --
> Atte.
> �lvaro Palma Aste
> Grupo de Ing Biom�dica - U. de Chile
> apalma_at_cec.uchile.adivina

Designer has the reconciliation tool for this purpose. I think you should know this before you are really wasting your time on reinventing something.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address