{
    "content": [
        {
            "type": "text",
            "text": "# DROP_STATISTICS (man)\n\n## NAME\n\nDROPSTATISTICS - remove extended statistics\n\n## SYNOPSIS\n\nDROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]\n\n## DESCRIPTION\n\nDROP 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\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **PARAMETERS**\n- **EXAMPLES**\n- **COMPATIBILITY**\n- **SEE ALSO**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "DROP_STATISTICS",
        "section": "",
        "mode": "man",
        "summary": "DROPSTATISTICS - remove extended statistics",
        "synopsis": "DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "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"
            }
        ],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 3,
                "subsections": []
            },
            {
                "name": "PARAMETERS",
                "lines": 11,
                "subsections": []
            },
            {
                "name": "EXAMPLES",
                "lines": 6,
                "subsections": []
            },
            {
                "name": "COMPATIBILITY",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 5,
                "subsections": []
            }
        ],
        "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": []
            }
        }
    }
}