Why use trigger's in DBMS?
2294
29-Sep-2015
home / developersection / interviews / why use trigger's in dbms?
Aryan Kumar
19-May-2023Triggers are used in DBMS to perform a predefined action when a specific event occurs in the database. They are a powerful tool that can be used to enforce data integrity, implement business rules, and automate tasks.
Here are some of the reasons why you might use triggers in DBMS:
Triggers can be a powerful tool for managing your database. By using triggers, you can enforce data integrity, implement business rules, and automate tasks.
Here are some of the advantages of using triggers:
Here are some of the disadvantages of using triggers:
Overall, triggers are a powerful tool that can be used to manage your database. However, they can also impact the performance and security of your database. It is important to weigh the pros and cons of using triggers before deciding whether or not to use them.
zack mathews
29-Sep-2015In a DBMS, a trigger is a SQL procedure that initiates an action when an DML operation (INSERT, DELETE or UPDATE) occurs. So we can say that triggers are event-driven specialized procedures, they are stored in and managed by the DBMS.
A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion.