DROP TIMESERIES POLICY

Function

For deleting existing data retention policies.

Precautions

• If the data retention policy is being used by a time-series table, it cannot be deleted.
• The default policy under the database cannot be deleted.

Syntax Format

DROP TIMESERIES POLICY [IF EXISTS] policy_name

This syntax is used for deleting one or more time-series retention policies.

If there is no the IF EXISTS option and a non-existent policy occurs in the policy list to be deleted, the deletion will fail, an error message is reported, and any policy is not deleted.

If the IF EXISTS option is included and a non-existent policy occurs in the policy list to be deleted, the non-existent policy is skipped, a prompt message is reported, and the policies are deleted except the non-existent one.

Examples

Uqbar=# DROP TIMESERIES POLICY policy1;
DROP POLICY

Related Pages

CREATE TIMESERIES POLICY, ALTER TIMESERIES POLICY