Help Center/ Data Warehouse Service / More Documents/ SQL Syntax Reference (Kuala Lumpur Region)/ DDL Syntax/ DROP STATISTICS
Updated on 2025-10-11 GMT+08:00
View PDF
Share

DROP STATISTICS

Function

Deletes an extended statistics object. This syntax is supported only by clusters of version 8.2.1.200 or later.

Precautions

None

Syntax

1
 
DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Parameter Description

Table 1 DROP STATISTICS parameters

Parameter

Description

Value Range

IF EXISTS

Sends a notification rather than reporting an error if the specified extended statistics object does not exist.

-

name

Indicates the name of the extended statistics object to be deleted.

An existing extended statistics object name.

CASCADE | RESTRICT

This parameter does not take effect. No objects depend on extended statistics objects.

-

Examples

Deletes an extended statistics object. 
DROP STATISTICS s1_t1_row;

Helpful Links

CREATE STATISTICS

Parent Topic: DDL Syntax