Trigger in SQL Server:-

  • A Trigger is a Database object just like a stored procedure or we can say it is a special kind of Stored Procedure which fires when an event occurs in a database."
  • It is a database object that is bound to a table and is executed automatically.
  • We cannot explicitly call any trigger.
  • Triggers provide data integrity and used to access and check data before and after modification using DDL or DML query.

Type of Triggers

There are two types of Triggers:

  1. DDL Trigger
  2. DML trigger

results matching ""

    No results matching ""