PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

DROP RULE

劉䓄

DROP RULE -- 役鍴婔婻麉喍蓇彍

臺濘

DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ]

柟誄

DROP RULE 役鍴婔婻蓇彍㔗

埗昄

IF EXISTS

套悩毺垔䔇蓇彍婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗

name

襕役鍴䔇䯄庻蓇彍劉䓄

relation

臖蓇彍庫䫘䔇噿係劉庖(埇傖橬昇嚟媞閄)

CASCADE

亓蕫役鍴冺蕡庯溴蓇彍䔇凹茇

RESTRICT

套悩橬傂嘘冺蕡凹茇彍拐䂺役鍴溴蓇彍㔗認婻滇䚺䩕㔗

冋床

役鍴麉喍蓇彍 newrule

DROP RULE newrule ON mytable;

噚垹攓

SQL 湺庖麯澇橬 DROP RULE 臺埖㔗

埽蓕

CREATE RULE

劯锔饡釕嬉誕
DROP ROLE婪婔亓DROP SCHEMA