solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables : SYS_FEDT_TABLE_PARTITION
  
SYS_FEDT_TABLE_PARTITION
The SYS_FEDT_TABLE_PARTITION table provides a mapping between tables and Logreader partitions.
 
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 (user name). 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
Go up to
System tables