aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pgaccess/lib/help/drop_trigger.hlp
blob: 8a3d69e6dbd800dadf77c5eee5931e7a0bcc7d79 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
.pgaw:Help.f.t insert end "DROP TRIGGER" {bold} " will remove all references to an existing trigger definition. To execute this command the current user must be the owner of the trigger. 

" {} "Synopsis" {bold} "

DROP TRIGGER name ON table

" {} "Usage" {bold} "

Destroy the if_dist_exists trigger on table films: 

DROP TRIGGER if_dist_exists ON films;

" {} "Notes" {bold} "

DROP TRIGGER is a Postgres language extension. 

Refer to CREATE TRIGGER for information on how to create triggers. "