Triggers are defined as stored programs which are automatically executed whenever some events such as CREATE, ALTER, UPDATE, INSERT, DELETE takes place.They can be defined on a database, table, view with which event is associated.
Triggers can be broadly classified into Row Level and Statement Level triggers.
Broadly, these can be differentiated as:
|Row Level Triggers||Statement Level Triggers|
|Row level triggers executes once for each and every row in the transaction.||Statement level triggers executes only once for each single transaction.|
|Specifically used for data auditing purpose.||Used for enforcing all additional security on the transactions performed on the table.|
|“FOR EACH ROW” clause is present in CREATE TRIGGER command.||“FOR EACH ROW” clause is omitted in CREATE TRIGGER command.|
|Example: If 1500 rows are to be inserted into a table, the row level trigger would execute 1500 times.||Example: If 1500 rows are to be inserted into a table, the statement level trigger would execute only once.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.