Database automation

[gordy]

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

[charge]

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