• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Triggers

Triggers are special stored procedures that are executed automatically when specific database activity occurs. Triggers may be associated with INSERT, UPDATE, and DELETE operations on specific tables (or any combination thereof).

Unlike stored procedures (which are simply stored SQL statements), triggers are tied to individual tables. A trigger associated with INSERT operations on an Orders table will be executed only when a row is inserted into that Orders table. Similarly, a trigger on INSERT and UPDATE operations on a Customers table will be executed only when those specific operations occur on that table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint