Difference between Trigger and Procedure in DBMS

1. Procedures :
A procedure is a combination of SQL statements written to perform a specified tasks. It helps in code re-usability and saves time and lines of code.

2. Triggers :
A trigger is a special kind of procedure which executes only when some triggering event such as INSERT, UPDATE, DELETE operations occurs in a table.

Difference between Triggers and Procedures :

Triggers Procedures
A Trigger is implicitly invoked whenever any event such as INSERT, DELETE, UPDATE occurs in a TABLE. A Procedure is explicitly called by user/application using statements or commands such as exec, EXECUTE, or simply procedure_name
Only nesting of triggers can be achieved in a table. We cannot define/call a trigger inside another trigger. We can define/call procedures inside another procedure.
In a database, syntax to define a trigger: CREATE TRIGGER TRIGGER_NAME In a database, syntax to define a procedure: CREATE PROCEDURE PROCEDURE_NAME
Transaction statements such as COMMIT, ROLLBACK, SAVEPOINT are not allowed in triggers. All transaction statements such as COMMIT, ROLLBACK are allowed in procedures.
Triggers are used to maintain referencial integrity by keeping a record of activities performed on the table. Procedures are used to perform tasks defined or specified by the users.
We cannot return values in a trigger. Also, as an input, we cannot pass values as a parameter. We can return 0 to n values. However, we can pass values as parameters.

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.