DROP TRIGGER

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

---

NAME

DROP TRIGGER - å é¤ä¸ä¸ªè§¦åå¨å®ä¹

SYNOPSIS

DROP TRIGGER name ON table [ CASCADE | RESTRICT ]

DESCRIPTION æè¿°

DROP TRIGGER å°å é¤ææ对ä¸ä¸ªç°å触åå¨çå¼ç¨ã è¦æ§è¡è¿ä¸ªå½ä»¤ï¼å½åç¨æ·å¿é¡»æ¯è§¦åå¨çææèã

PARAMETERS åæ°

name

è¦å é¤ç触åå¨åã

table

触åå¨å®ä¹æå¨ç表çå称ï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ã

CASCADE

èªå¨å é¤ä¾èµæ¤è§¦åå¨ç对象ã

RESTRICT

å¦ææä»»ä½ä¾èµå¯¹è±¡åå¨ï¼é£ä¹æç»å é¤ãè¿ä¸ªæ¯ç¼ºçã

EXAMPLES ä¾å

å é¤è¡¨filmsçif_dist_exists触åå¨ï¼

DROP TRIGGER if_dist_exists ON films;

COMPATIBILITY å¼å®¹æ§

PostgreSQL éç DROP TRIGGER è¯å¥å SQL æ åä¸å¼å®¹ãå¨ SQL æ åéï¼è§¦åå¨åå- ä¸æ¯è¡¨æå±é¨æ¥æçï¼æ以å½ä»¤åªæ¯ç®åç DROP TRIGGER nameã

SEE ALSO åè§

CREATE TRIGGER [create_trigger(7)]

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---