What are the types of triggers ?
Answers were Sorted based on User's Feedback
Answer / sam katwal
There are three types of Triggers
Insert Trigger
Update Trigger
Delete Trigger
One Trigger also exists
Instead of Trigger which was introducted in SQL Server 2000
| Is This Answer Correct ? | 21 Yes | 24 No |
Answer / 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 |
Answer / arjun singh
INSERT TRIGGER
UPDATE TRIGGER
DELETE TRIGGER
| Is This Answer Correct ? | 7 Yes | 22 No |
what are the security recommendations while using mysql? : Sql dba
What is a composite primary key?
Explain Connect by Prior?
What is varchar data type in sql?
Which is better stored procedure or query?
what is try_catch block in procedure
What sql database should I use?
how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
What is right join sql?
What does trigger mean in slang?
What is meant by <> in sql?
There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)