Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

How many types of database triggers can be specified on a table ?

5 like 0 dislike
How many types of database triggers can be specified on a table ? What are they ?
asked 1 year ago by marck_don (191,010 points)

1 Answer

1 like 0 dislike
 
Best answer
Insert Update Delete
Before Row o.k. o.k. o.k.
After Row o.k. o.k. o.k.
Before Statement o.k. o.k. o.k.
After Statement o.k. o.k. o.k.
If FOR EACH ROW clause is specified, then the trigger for each Row affected by the statement.
If WHEN clause is specified, the trigger fires according to the returned Boolean value.
answered 1 year ago by daneim (127,080 points)

Related questions

3 like 0 dislike
1 answer
asked 1 year ago by rad_joshep (19,390 points)
6 like 0 dislike
1 answer
6 like 0 dislike
1 answer
asked 1 year ago by marck_don (191,010 points)
6 like 0 dislike
1 answer
2 like 0 dislike
0 answers