{
    "name": "DROP_TRIGGER(7)",
    "mode": "man",
    "parameter": "DROP_TRIGGER",
    "section": "7",
    "url": "/phpMan.php/man/DROP_TRIGGER/7/json",
    "generated": "2026-05-27T10:56:29Z",
    "synopsis": "DROP TRIGGER [ IF EXISTS ] name ON tablename [ CASCADE | RESTRICT ]",
    "sections": [
        {
            "name": "NAME",
            "level": 1,
            "content": "DROPTRIGGER - remove a trigger\n",
            "subsections": []
        },
        {
            "name": "SYNOPSIS",
            "level": 1,
            "content": "DROP TRIGGER [ IF EXISTS ] name ON tablename [ CASCADE | RESTRICT ]\n",
            "subsections": []
        },
        {
            "name": "DESCRIPTION",
            "level": 1,
            "content": "DROP TRIGGER removes an existing trigger definition. To execute this command, the current\nuser must be the owner of the table for which the trigger is defined.\n",
            "subsections": []
        },
        {
            "name": "PARAMETERS",
            "level": 1,
            "content": "IF EXISTS\nDo not throw an error if the trigger does not exist. A notice is issued in this case.\n\nname\nThe name of the trigger to remove.\n\ntablename\nThe name (optionally schema-qualified) of the table for which the trigger is defined.\n\nCASCADE\nAutomatically drop objects that depend on the trigger, and in turn all objects that\ndepend on those objects (see Section 5.14).\n\nRESTRICT\nRefuse to drop the trigger if any objects depend on it. This is the default.\n",
            "subsections": []
        },
        {
            "name": "EXAMPLES",
            "level": 1,
            "content": "Destroy the trigger ifdistexists on the table films:\n\nDROP TRIGGER ifdistexists ON films;\n",
            "subsections": []
        },
        {
            "name": "COMPATIBILITY",
            "level": 1,
            "content": "The DROP TRIGGER statement in PostgreSQL is incompatible with the SQL standard. In the SQL\nstandard, trigger names are not local to tables, so the command is simply DROP TRIGGER name.\n",
            "subsections": [
                {
                    "name": "SEE ALSO",
                    "level": 2,
                    "content": "CREATE TRIGGER (CREATETRIGGER(7))\n\n\n"
                }
            ]
        },
        {
            "name": "PostgreSQL 14.23                                2026                                 DROP TRIGGER(7)",
            "level": 1,
            "content": "",
            "subsections": []
        }
    ]
}