1DROP STATISTICS(7)       PostgreSQL 12.2 Documentation      DROP STATISTICS(7)
2
3
4

NAME

6       DROP_STATISTICS - remove extended statistics
7

SYNOPSIS

9       DROP STATISTICS [ IF EXISTS ] name [, ...]
10

DESCRIPTION

12       DROP STATISTICS removes statistics object(s) from the database. Only
13       the statistics object's owner, the schema owner, or a superuser can
14       drop a statistics object.
15

PARAMETERS

17       IF EXISTS
18           Do not throw an error if the statistics object does not exist. A
19           notice is issued in this case.
20
21       name
22           The name (optionally schema-qualified) of the statistics object to
23           drop.
24

EXAMPLES

26       To destroy two statistics objects in different schemas, without failing
27       if they don't exist:
28
29           DROP STATISTICS IF EXISTS
30               accounting.users_uid_creation,
31               public.grants_user_role;
32

COMPATIBILITY

34       There is no DROP STATISTICS command in the SQL standard.
35

SEE ALSO

37       ALTER STATISTICS (ALTER_STATISTICS(7)), CREATE STATISTICS
38       (CREATE_STATISTICS(7))
39
40
41
42PostgreSQL 12.2                      2020                   DROP STATISTICS(7)