Column name
|
Data type
|
Description
|
---|---|---|
TABLE_CATALOG
|
VARCHAR(255)
|
This column indicates the catalog name.
Each table has an associated catalog name. A catalog is created in when the database is created, or afterwards by using a CREATE CATALOG statement. There is no factory value for a catalog name.
|
TABLE_SCHEMA
|
VARCHAR(255)
|
This column indicates the schema name.
Each table has an associated schema name. By default, the schema name is the user ID (username). A schema may be also created by using the CREATE SCHEMA statement.
|
PARTITION_ID
|
CHAR(30)
|
This column indicates the partition name.
This column is a foreign key to the FEDT_TABLE_PARTITION table.
|
BE_TABLE_DATABASE
|
VARCHAR(255)
|
Not used
|
BE_TABLE_SCHEMA
|
VARCHAR(255)
|
Not used
|
BE_TABLE_NAME
|
CHAR(30)
|
Not used
|
RANGE_COL_NAME
|
CHAR(30)
|
Not used
|
LOWER_LIMIT
|
VARCHAR(255)
|
Not used
|
UPPER_LIMIT
|
VARCHAR(255)
|
Not used
|
SELECT_LIST
|
VARCHAR(255)
|
Not used
|
LOADORDER
|
INTEGER
|
Not used
|