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 autopool`nnnnnnnn`, 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';