Home > DeveloperSection > Interviews > Why use trigger's in DBMS?

Posted on    September-29-2015 1:21 AM

 SQLite Database  Sqlite  Sqlite3 
 1 Answer(s)
  607  View(s)
Rate this:

zack mathews
zack mathews

Total Post:5

Posted on    September-29-2015 1:21 AM

In 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.

Don't want to miss updates? Please click the below button!

Follow MindStick