TSContainerDestroy procedure

The TSContainerDestroy procedure deletes the container row from the TSContainerTable table and removes the container and its corresponding system catalog rows.

Syntax

TSContainerDestroy(container_name varchar(128,1));
container_name
The name of the container to destroy.

Description

You can destroy a container only if no time series exist in that container; even an empty time series prevents a container from being destroyed.

Only users with update privileges on the TSContainerTable table can run this procedure.

Example

The following example destroys the container ctnr_stock:
execute procedure TSContainerDestroy('ctnr_stock');