{
    "mode": "man",
    "parameter": "DROP_DOMAIN",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/DROP_DOMAIN/7/json",
    "generated": "2026-05-30T05:10:04Z",
    "synopsis": "DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]",
    "sections": {
        "NAME": {
            "content": "DROPDOMAIN - remove a domain\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "DROP DOMAIN removes a domain. Only the owner of a domain can remove it.\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "IF EXISTS\nDo not throw an error if the domain does not exist. A notice is issued in this case.\n\nname\nThe name (optionally schema-qualified) of an existing domain.\n\nCASCADE\nAutomatically drop objects that depend on the domain (such as table columns), and in turn\nall objects that depend on those objects (see Section 5.14).\n\nRESTRICT\nRefuse to drop the domain if any objects depend on it. This is the default.\n",
            "subsections": []
        },
        "EXAMPLES": {
            "content": "To remove the domain box:\n\nDROP DOMAIN box;\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "This command conforms to the SQL standard, except for the IF EXISTS option, which is a\nPostgreSQL extension.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "CREATE DOMAIN (CREATEDOMAIN(7)), ALTER DOMAIN (ALTERDOMAIN(7))\n\n\n\nPostgreSQL 14.23                                2026                                  DROP DOMAIN(7)",
            "subsections": []
        }
    },
    "summary": "DROPDOMAIN - remove a domain",
    "flags": [],
    "examples": [
        "To remove the domain box:",
        "DROP DOMAIN box;"
    ],
    "see_also": [
        {
            "name": "CREATEDOMAIN",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/CREATEDOMAIN/7/json"
        },
        {
            "name": "ALTERDOMAIN",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/ALTERDOMAIN/7/json"
        },
        {
            "name": "DOMAIN",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/DOMAIN/7/json"
        }
    ]
}