DROP TRIGGER
劉䓄
DROP TRIGGER -- 役鍴婔婻蓥埏単
臺濘
DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ]
柟誄
DROP TRIGGER 儖役鍴欔橬凹婔婻䯄庻蓥埏単䔇嚘䫘㔗襕欓臯認婻变傴嘷嬉䫘潙媙釂滇蓥埏単䔇欔橬蔙㔗
埗昄
- IF EXISTS
套悩毺垔䔇蓥埏単婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗
- name
襕役鍴䔇蓥埏単劉
- table
蓥埏単垔幬欔婘䔇臘䔇劉䓄(埇傖橬昇嚟媞閄)
- CASCADE
亓蕫役鍴冺蕡溴蓥埏単䔇凹茇
- RESTRICT
套悩橬傂嘘冺蕡凹茇庻婘闼幽拐䂺役鍴㔗認婻滇䚺䩕㔗
冋床
役鍴 films 臘䔇 if_dist_exists 蓥埏単
DROP TRIGGER if_dist_exists ON films;
噚垹攓
PostgreSQL 麯䔇 DROP TRIGGER 臺埖启 SQL 湺庖婉噚垹㔗婘 SQL 湺庖麯蓥埏単劉庖婉滇臘欔匔鄘拖橬䔇欔傖变傴埻滇䞔剘䔇 DROP TRIGGER name