Advantages and Disadvantages of Trigger

In this topic, you will learn about, Advantages and disadvantages of a trigger.

A trigger in SQL is a sequence of actions that results in a change in the table of a database. It is activated when the contents of the table of a database are modified.

Advantages of triggers:

  • It executes randomly.
  • It cannot consume any memory space.
  • It executes automatically according to the event.
  • It can directly link with the database table and perform any changes.
  • It can use a DML statement.
  • It is used with the server computer.

Disadvantages of Trigger:

  • Its results are not stored permanently.
  • It works only with a client-server architecture.
  • It uses only insert, delete, and update commands from DML.
  • It specifies the procedural environment.
  • It enforces constant.
  • It doesn’t apply to the Data integrity constant.

Comment below if you have queries related to the above topic, Advantages, and disadvantages of a trigger.

See also  What is joins Discuss the different types of Joins