Reference Guide > TDV and Business Directory System Tables > ALL_RELATIONSHIP_COLUMNS
 
ALL_RELATIONSHIP_COLUMNS
The ALL_RELATIONSHIP_COLUMNS system table exposes the columns of all relationships to which the current user has access. Users can see relationship columns if they have privileges on the tables involved.
For further information about this system table, see the Discovery User Guide.
Column
TDV JDBC Data Type
Nullable
Description
RELATIONSHIP_ID
INTEGER
 
Identifier of the relationship.
ORDINAL_POSITION
INTEGER
 
The order in which this column appears in the relationship.
FROM_COLUMN_ID
INTEGER
 
Identifier of the “from” column in the relationship.
FROM_COLUMN_NAME
VARCHAR(255)
 
Name of the “from” column in the relationship.
FROM_COLUMN_DATA_TYPE
VARCHAR(255)
 
Data type of the “from” column in the relationship.
FROM_TABLE_ID
INTEGER
 
Identifier of the “from” table in the relationship.
FROM_TABLE_NAME
VARCHAR(255)
 
Name of the “from” table in the relationship.
FROM_SCHEMA_ID
INTEGER
Yes
Identifier of the “from” schema in the relationship.
FROM_SCHEMA_NAME
VARCHAR(255)
Yes
Name of the “from” schema in the relationship.
FROM_CATALOG_ID
INTEGER
Yes
Identifier of the “from” catalog in the relationship.
FROM_CATALOG_NAME
VARCHAR(255)
Yes
Name of the “from” catalog in the relationship.
FROM_DATASOURCE_ID
INTEGER
 
Identifier of the “from” data source in the relationship.
FROM_DATASOURCE_NAME
VARCHAR(255)
 
Name of the “from” data source in the relationship.
TO_COLUMN_ID
INTEGER
 
Identifier of the “to” column in the relationship.
TO_COLUMN_NAME
VARCHAR(255)
 
Name of the “to” column in the relationship.
TO_COLUMN_DATA_TYPE
VARCHAR(255)
Yes
Data type of the “to” column in the relationship.
TO_TABLE_ID
INTEGER
 
Identifier of the “to” table in the relationship.
TO_TABLE_NAME
VARCHAR(255)
 
Name of the “to” table in the relationship.
TO_SCHEMA_ID
INTEGER
Yes
Identifier of the “to” schema in the relationship.
TO_SCHEMA_NAME
VARCHAR(255)
Yes
Name of the “to” schema in the relationship.
TO_CATALOG_ID
INTEGER
Yes
Identifier of the “to” catalog in the relationship.
TO_CATALOG_NAME
VARCHAR(255)
Yes
Name of the “to” catalog in the relationship.
TO_DATASOURCE_ID
INTEGER
 
Identifier of the “to” data source in the relationship.
TO_DATASOURCE_NAME
VARCHAR(255)
 
Name of the “to” data source in the relationship.
OWNER_ID
INTEGER
 
Identifier of the person who created or owns the procedure.
OWNER
VARCHAR(255)
 
User name of the person who created or owns the procedure.
FROM_DATA_OBJECT_NAME
VARCHAR(2147483647)
 
Name of the “from” data object in the relationship.
TO_DATA_OBJECT_NAME
VARCHAR(2147483647)
 
Name of the “to” data object in the relationship.