dk02151
asked on
Question about ADO OpenSchema method relating to Oracle
I am trying to read the foreign keys of our Oracle database with ADO's OpenSchema method using the adSchemaForeignKeys constant. I am retrieving the information but I am having a little bit of trouble interpreting what I get back. The Ordinal field that I get is what I have a question about. I can't find this in any of the Oracle DBA tables. I assume that this must be something that ADO is generating. My question is how does ADO generate the Ordinal field value and what does it mean? An example of three records from the OpenSchema method is as follows:
PK_TABLE_CATALOG Null
PK_TABLE_SCHEMA DA01
PK_TABLE_NAME CRT009_QUEUE
PK_COLUMN_NAME DEPARTMENTCODE
PK_COLUMN_GUID Null
PK_COLUMN_PROPID Null
FK_TABLE_CATALOG Null
FK_TABLE_SCHEMA DA01
FK_TABLE_NAME CRT030_USERPROFILE
FK_COLUMN_NAME DEPARTMENTCODE
FK_COLUMN_GUID Null
FK_COLUMN_PROPID Null
ORDINAL 3
UPDATE_RULE NO ACTION
DELETE_RULE NO ACTION
PK_NAME CRX0090
FK_NAME CRR030_CRT009
DEFERRABILITY 3
PK_TABLE_CATALOG Null
PK_TABLE_SCHEMA DA01
PK_TABLE_NAME CRT013_TEAM
PK_COLUMN_NAME DEPARTMENTCODE
PK_COLUMN_GUID Null
PK_COLUMN_PROPID Null
FK_TABLE_CATALOG Null
FK_TABLE_SCHEMA DA01
FK_TABLE_NAME CRT030_USERPROFILE
FK_COLUMN_NAME DEPARTMENTCODE
FK_COLUMN_GUID Null
FK_COLUMN_PROPID Null
ORDINAL 3
UPDATE_RULE NO ACTION
DELETE_RULE NO ACTION
PK_NAME CRX0130
FK_NAME CRR030_CRT013
DEFERRABILITY 3
PK_TABLE_CATALOG Null
PK_TABLE_SCHEMA DA01
PK_TABLE_NAME CRT002_DEPARTMENT
PK_COLUMN_NAME DEPARTMENTCODE
PK_COLUMN_GUID Null
PK_COLUMN_PROPID Null
FK_TABLE_CATALOG Null
FK_TABLE_SCHEMA DA01
FK_TABLE_NAME CRT030_USERPROFILE
FK_COLUMN_NAME DEPARTMENTCODE
FK_COLUMN_GUID Null
FK_COLUMN_PROPID Null
ORDINAL 2
UPDATE_RULE NO ACTION
DELETE_RULE NO ACTION
PK_NAME CRX0020
FK_NAME CRR030_CRT002
DEFERRABILITY 3
PK_TABLE_CATALOG Null
PK_TABLE_SCHEMA DA01
PK_TABLE_NAME CRT009_QUEUE
PK_COLUMN_NAME DEPARTMENTCODE
PK_COLUMN_GUID Null
PK_COLUMN_PROPID Null
FK_TABLE_CATALOG Null
FK_TABLE_SCHEMA DA01
FK_TABLE_NAME CRT030_USERPROFILE
FK_COLUMN_NAME DEPARTMENTCODE
FK_COLUMN_GUID Null
FK_COLUMN_PROPID Null
ORDINAL 3
UPDATE_RULE NO ACTION
DELETE_RULE NO ACTION
PK_NAME CRX0090
FK_NAME CRR030_CRT009
DEFERRABILITY 3
PK_TABLE_CATALOG Null
PK_TABLE_SCHEMA DA01
PK_TABLE_NAME CRT013_TEAM
PK_COLUMN_NAME DEPARTMENTCODE
PK_COLUMN_GUID Null
PK_COLUMN_PROPID Null
FK_TABLE_CATALOG Null
FK_TABLE_SCHEMA DA01
FK_TABLE_NAME CRT030_USERPROFILE
FK_COLUMN_NAME DEPARTMENTCODE
FK_COLUMN_GUID Null
FK_COLUMN_PROPID Null
ORDINAL 3
UPDATE_RULE NO ACTION
DELETE_RULE NO ACTION
PK_NAME CRX0130
FK_NAME CRR030_CRT013
DEFERRABILITY 3
PK_TABLE_CATALOG Null
PK_TABLE_SCHEMA DA01
PK_TABLE_NAME CRT002_DEPARTMENT
PK_COLUMN_NAME DEPARTMENTCODE
PK_COLUMN_GUID Null
PK_COLUMN_PROPID Null
FK_TABLE_CATALOG Null
FK_TABLE_SCHEMA DA01
FK_TABLE_NAME CRT030_USERPROFILE
FK_COLUMN_NAME DEPARTMENTCODE
FK_COLUMN_GUID Null
FK_COLUMN_PROPID Null
ORDINAL 2
UPDATE_RULE NO ACTION
DELETE_RULE NO ACTION
PK_NAME CRX0020
FK_NAME CRR030_CRT002
DEFERRABILITY 3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will leave a recommendation in the Cleanup topic area that this question is:
- answered by Dhaest
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
ayufans
Cleanup Volunteer