{
    "content": [
        {
            "type": "text",
            "text": "# DROP_RULE(7) (man)\n\n**Summary:** DROPRULE - remove a rewrite rule\n\n**Synopsis:** DROP RULE [ IF EXISTS ] name ON tablename [ CASCADE | RESTRICT ]\n\n## Examples\n\n- `To drop the rewrite rule newrule:`\n- `DROP RULE newrule ON mytable;`\n\n## See Also\n\n- CREATERULE(7)\n- ALTERRULE(7)\n- RULE(7)\n\n## Section Outline\n\n- **NAME** (2 lines)\n- **SYNOPSIS** (2 lines)\n- **DESCRIPTION** (2 lines)\n- **PARAMETERS** (16 lines)\n- **EXAMPLES** (4 lines)\n- **COMPATIBILITY** (2 lines)\n- **SEE ALSO** (5 lines)\n\n## Full Content\n\n### NAME\n\nDROPRULE - remove a rewrite rule\n\n### SYNOPSIS\n\nDROP RULE [ IF EXISTS ] name ON tablename [ CASCADE | RESTRICT ]\n\n### DESCRIPTION\n\nDROP RULE drops a rewrite rule.\n\n### PARAMETERS\n\nIF EXISTS\nDo not throw an error if the rule does not exist. A notice is issued in this case.\n\nname\nThe name of the rule to drop.\n\ntablename\nThe name (optionally schema-qualified) of the table or view that the rule applies to.\n\nCASCADE\nAutomatically drop objects that depend on the rule, and in turn all objects that depend\non those objects (see Section 5.14).\n\nRESTRICT\nRefuse to drop the rule if any objects depend on it. This is the default.\n\n### EXAMPLES\n\nTo drop the rewrite rule newrule:\n\nDROP RULE newrule ON mytable;\n\n### COMPATIBILITY\n\nDROP RULE is a PostgreSQL language extension, as is the entire query rewrite system.\n\n### SEE ALSO\n\nCREATE RULE (CREATERULE(7)), ALTER RULE (ALTERRULE(7))\n\n\n\nPostgreSQL 14.23                                2026                                    DROP RULE(7)\n\n"
        }
    ],
    "structuredContent": {
        "command": "DROP_RULE",
        "section": "7",
        "mode": "man",
        "summary": "DROPRULE - remove a rewrite rule",
        "synopsis": "DROP RULE [ IF EXISTS ] name ON tablename [ CASCADE | RESTRICT ]",
        "flags": [],
        "examples": [
            "To drop the rewrite rule newrule:",
            "DROP RULE newrule ON mytable;"
        ],
        "see_also": [
            {
                "name": "CREATERULE",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/CREATERULE/7/json"
            },
            {
                "name": "ALTERRULE",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/ALTERRULE/7/json"
            },
            {
                "name": "RULE",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/RULE/7/json"
            }
        ],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "PARAMETERS",
                "lines": 16,
                "subsections": []
            },
            {
                "name": "EXAMPLES",
                "lines": 4,
                "subsections": []
            },
            {
                "name": "COMPATIBILITY",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 5,
                "subsections": []
            }
        ]
    }
}