Reference Guide > TDV and Business Directory System Tables > ALL_COLUMNS
 
ALL_COLUMNS
The ALL_COLUMNS system table exposes all columns in all published tables in all published data sources to which the current user has access.
Column
TDV
JDBC Data Type
Nullable
Description
COLUMN_ID
INTEGER
 
Identifier of the column. Primary key.
COLUMN_NAME
VARCHAR(255)
 
Name of the column.
DATA_TYPE
VARCHAR(255)
 
String representation of the data type.
ORDINAL_POSITION
INTEGER
 
Position of this column in relation to other columns in the same table.
JDBC_DATA_TYPE
SMALLINT
 
JDBC/ODBC data types.
For JDBC data types refer to: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html
For ODBC data types refer to:
http://msdn.microsoft.com/en-us/library/bb630290.aspx
COLUMN_LENGTH
INTEGER
Yes
For CHAR or VARCHAR columns, the max length allowed.
For DECIMAL or NUMERIC columns, the total number of digits is the column length value.
If it is not one of these four types, the value is NULL.
COLUMN_PRECISION
INTEGER
Yes
For a column of DECIMAL or NUMERIC data type, the value is the number of digits.
For a column that is not a DECIMAL or NUMERIC data type, the value is NULL.
COLUMN_SCALE
INTEGER
Yes
For a column value of DECIMAL or NUMERIC data type, this is the exponent.
COLUMN_RADIX
INTEGER
Yes
10—for all NUMERIC data types.
Null—for all non-numeric data types.
NULLABLE
SMALLINT
 
Indicates whether the column is nullable:
0—NULL is not allowed.
1—NULL is allowed.
2—Unknown whether NULL is allowed or not.
IS_NULLABLE
VARCHAR(255)
 
Indicates whether the column is nullable:
YES—Column is nullable.
NO—Column is not nullable.
Blank string is returned if it is not known.
TABLE_ID
INTEGER
 
Identifier of the table.
TABLE_NAME
VARCHAR(255)
 
Name of the table.
SCHEMA_ID
INTEGER
Yes
Identifier of the schema.
SCHEMA_NAME
VARCHAR(255)
Yes
Name of the schema.
CATALOG_ID
INTEGER
Yes
Identifier of the catalog.
CATALOG_NAME
VARCHAR(255)
Yes
Name of the catalog.
DATASOURCE_ID
INTEGER
 
Identifier of the data source.
DATASOURCE_NAME
VARCHAR(255)
 
Name of the data source.
BD_DATASOURCE_NAME
VARCHAR(255)
 
BD name of the data source.
ANNOTATION
VARCHAR(2147483647)
Yes
Annotation for the column.
OWNER_ID
INTEGER
 
Identifier for the user who created or owns the column.
OWNER
VARCHAR(255)
 
User name of the person who created or owns the column.
PARENT_PATH
VARCHAR(1043)
 
Path to the parent container.
BD_PARENT_PATH
VARCHAR(1043)
 
BD path to the parent container.