{
    "mode": "man",
    "parameter": "DROP_STATISTICS",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/DROP_STATISTICS/7/json",
    "generated": "2026-07-05T13:10:50Z",
    "synopsis": "DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]",
    "sections": {
        "NAME": {
            "content": "DROPSTATISTICS - remove extended statistics\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "DROP STATISTICS removes statistics object(s) from the database. Only the statistics object's\nowner, the schema owner, or a superuser can drop a statistics object.\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "IF EXISTS\nDo not throw an error if the statistics object does not exist. A notice is issued in this\ncase.\n\nname\nThe name (optionally schema-qualified) of the statistics object to drop.\n\nCASCADE\nRESTRICT\nThese key words do not have any effect, since there are no dependencies on statistics.\n",
            "subsections": []
        },
        "EXAMPLES": {
            "content": "To destroy two statistics objects in different schemas, without failing if they don't exist:\n\nDROP STATISTICS IF EXISTS\naccounting.usersuidcreation,\npublic.grantsuserrole;\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "There is no DROP STATISTICS command in the SQL standard.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "ALTER STATISTICS (ALTERSTATISTICS(7)), CREATE STATISTICS (CREATESTATISTICS(7))\n\n\n\nPostgreSQL 14.23                                2026                              DROP STATISTICS(7)",
            "subsections": []
        }
    },
    "summary": "DROPSTATISTICS - remove extended statistics",
    "flags": [],
    "examples": [
        "To destroy two statistics objects in different schemas, without failing if they don't exist:",
        "DROP STATISTICS IF EXISTS",
        "accounting.usersuidcreation,",
        "public.grantsuserrole;"
    ],
    "see_also": [
        {
            "name": "ALTERSTATISTICS",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/ALTERSTATISTICS/7/json"
        },
        {
            "name": "CREATESTATISTICS",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/CREATESTATISTICS/7/json"
        },
        {
            "name": "STATISTICS",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/STATISTICS/7/json"
        }
    ]
}