Show Posts
1
Automation Interface, Add-Ins and Tools / Database automation
« 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
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