TSContainerTable table

The TSContainerTable table has one row for each container.

Table 1. The columns in the TSContainerTable table
Column name Date type Description
name VARCHAR(128,1) The name of the container of the time series. The primary key of the table.

Containers that are created automatically are named autopoolnnnnnnnn, where n is a positive integer eight digits long with leading zeros.

subtype VARCHAR(128,1) The name of the time series subtype.
partitionDesc tsPartitionDesc_t The description of the partition for the container.
flags INTEGER Stores flags to indicate:
  • Whether the container is empty and always was empty.
  • Whether the time series is regular or irregular.
  • Whether the container is enabled for Enterprise Replication.
  • Whether the container is a rolling window container.
pool VARCHAR(128,1) DEFAULT NULL The name of the container pool to which the container belongs. NULL indicates that the container does not belong to a container pool. The default container pool is named autopool.

The TSContainerTable table is managed by the database server. Do not modify it directly. Rows in this table are automatically inserted or deleted when containers are created or destroyed.

You can create or destroy containers by using the TSContainerCreate and TSContainerDestroy procedures, which insert and delete rows in the TSContainerTable table.

To get a list of containers in the database, run the following query:
SELECT NAME FROM TSContainerTable;
To get a list of the containers in the default container pool, run the following query:
SELECT NAME FROM TSContainerTable 
WHERE pool = 'autopool';