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 |
|
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: |
|
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. |