What are the types of triggers ?
Answer Posted / sandeep chawdekar
there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger
dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing
instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs
system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
how to include numeric values in sql statements? : Sql dba
what are the different type of sql's statements ? : Sql dba
what is log shipping? : Sql dba
What is a heap in sql?
Explain sql data types?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How do I find duplicates in a single column in sql?
What is the difference between cluster and non-cluster index?
Which is faster truncate or drop?
What are views in sql?
Is ms sql traffic encrypted?
What are character functions?
What is sqlcontext?
what is a database? : Sql dba
What is the full form of sql?