Database view

[markc]

Hello
I'm new to EA so please bear with me..
I'm trying to model some existing Oracle database views using EA version 7.5 build 848. I've pulled the tables and views into the datamodel via the ODBC connector and the tables are shown OK but although the table~view dependencies were correctly identified. the view definition was empty. I've manually entered the SQL for the view definition but none of the column names are shown on the ER diagram.

What I want to be able to see is the the column mappings between the view and the tables (or at least to see the column names in the view). Is this possible ??

Regards

Mark

[Paolo F Cantoni]

Hi Mark,

Unfortunately, it's not.

However, a couple of years back, I did get Sparx to allow the specification of the Columns without affecting the generation of the view.  (Previously if you defined columns, they appeared in the forward engineered DDL - as duplicates).

So if you have some way of parsing the view and generating the column lists, you can populate the View elements with the Columns.

HTH,
Paolo

[markc]

Thanks Paolo
I'm not too worried about forward engineering as I'm merely trying to document some legacy structure.  I wasn't sure how to add columns so for the purposes of my documentation, I've added a text node and copied the DDL for the view into that. Not ideal but good enough for my purposes.

Thanks for the prompt response

Regards

Mark