COLUMN_ID

INTEGER

 

 

COLUMN_NAME

VARCHAR(255)

 

 

DATA_TYPE

VARCHAR(255)

 

 

ORDINAL_POSITION

INTEGER

 

 

JDBC_DATA_TYPE

SMALLINT

 

 

COLUMN_LENGTH

INTEGER

Yes

 

COLUMN_PRECISION

INTEGER

Yes

 

COLUMN_SCALE

INTEGER

Yes

 

COLUMN_RADIX

INTEGER

Yes

 

NULLABLE

SMALLINT

 

Indicates whether the column is nullable
-0 if NULL is not allowed
-1 if NULL is allowed
- 2 if it is unknown

IS_NULLABLE

VARCHAR(255)

 

Indicates whether the column is nullable
- YES if it is nullable
-NO if it is not nullable
-Blank string is returned if value is not known

TABLE_ID

INTEGER

 

 

TABLE_NAME

VARCHAR(255)

 

 

SCHEMA_ID

INTEGER

Yes

 

SCHEMA_NAME

VARCHAR(255)

Yes

 

CATALOG_ID

INTEGER

Yes

 

CATALOG_NAME

VARCHAR(255)

Yes

 

DATASOURCE_ID

INTEGER

 

 

DATASOURCE_NAME

VARCHAR(255)

 

 

ANNOTATION

VARCHAR(65535)

Yes

Annotation for the column.

OWNER_ID

INTEGER

 

Identifier for the user who created/owns the column. Same as USER_ID in Table: ALL_USERS

CID

INTEGER

 

Commit ID

HAS_COL_PRIV

SMALLINT

 

Not used