{
    "mode": "man",
    "parameter": "DROP_COLLATION",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/DROP_COLLATION/7/json",
    "generated": "2026-06-15T21:10:29Z",
    "synopsis": "DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]",
    "sections": {
        "NAME": {
            "content": "DROPCOLLATION - remove a collation\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "DROP COLLATION removes a previously defined collation. To be able to drop a collation, you\nmust own the collation.\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "IF EXISTS\nDo not throw an error if the collation does not exist. A notice is issued in this case.\n\nname\nThe name of the collation. The collation name can be schema-qualified.\n\nCASCADE\nAutomatically drop objects that depend on the collation, and in turn all objects that\ndepend on those objects (see Section 5.14).\n\nRESTRICT\nRefuse to drop the collation if any objects depend on it. This is the default.\n",
            "subsections": []
        },
        "EXAMPLES": {
            "content": "To drop the collation named german:\n\nDROP COLLATION german;\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "The DROP COLLATION command conforms to the SQL standard, apart from the IF EXISTS option,\nwhich is a PostgreSQL extension.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "ALTER COLLATION (ALTERCOLLATION(7)), CREATE COLLATION (CREATECOLLATION(7))\n\n\n\nPostgreSQL 14.23                                2026                               DROP COLLATION(7)",
            "subsections": []
        }
    },
    "summary": "DROPCOLLATION - remove a collation",
    "flags": [],
    "examples": [
        "To drop the collation named german:",
        "DROP COLLATION german;"
    ],
    "see_also": [
        {
            "name": "ALTERCOLLATION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/ALTERCOLLATION/7/json"
        },
        {
            "name": "CREATECOLLATION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/CREATECOLLATION/7/json"
        },
        {
            "name": "COLLATION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/COLLATION/7/json"
        }
    ]
}