Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: gordy on May 12, 2005, 07:57:15 am

Title: Database automation
Post by: gordy on May 12, 2005, 07:57:15 am

Hi,
I'm trying to programatically read information that I've created in a model.

I've created a simple table under the datamodel package which has the following structure:

PK Var1 NUMBER(5)
    Var2 VARCHAR2(50)

I am currently able to find table/column names, types and precision, but I'd like to be able to read whether a column is:
- a primary key
- not null
- unique

Can anyone please advise as to how I get this info from the object model.

Many thanks

Gordon

Title: Re: Database automation
Post by: charge on May 19, 2005, 12:56:20 am

Open the EAP file in MS Access and you can find the fields you have to use.
It's Q&D but it's possible  ::)