Are database triggers evil? [closed]

by

The main problems with triggers are

  • They are completely Global – they apply no matter what the context of the table activity;
  • They are stealthy; it’s easy to forget they are there until they hurt you with unintended (and very mysterious) consequences.

This just means they need to be carefully used for the proper circumstances; which in my experience is limited to relational integrity issues (sometimes with finer granularity than you can get declaratively); and usually not for business or transactional purposes. YMMV.

More Related Contents:

  1. Create Trigger to log SQL that affected table?
  2. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  3. Need to list all triggers in SQL Server database with table name and table’s schema
  4. How can I do a BEFORE UPDATED trigger with sql server?
  5. SQL Server Update Trigger, Get Only modified fields
  6. SQL Server 2008 – Help writing simple INSERT Trigger
  7. How do I prevent a database trigger from recursing?
  8. Sql Server trigger insert values from new row into another table
  9. SQL update trigger only when column is modified
  10. Postgres trigger after insert accessing NEW
  11. ORACLE After update trigger: solving ORA-04091 mutating table error
  12. Insert into … values ( SELECT … FROM … )
  13. How to create id with AUTO_INCREMENT on Oracle?
  14. Difference between EXISTS and IN in SQL?
  15. How should I pass a table name into a stored proc?
  16. PostgreSQL: using a calculated column in the same query
  17. How to delete duplicate rows without unique identifier
  18. SQL statement to get column type
  19. Reference an alias elsewhere in the SELECT list
  20. SQL update fields of one table from fields of another one
  21. ORA-00907: missing right parenthesis
  22. Foreign Key Creation issue in Oracle
  23. Android multiple databases open
  24. COPY with dynamic file name
  25. Is there a version control system for database structure changes?
  26. Find all records which have a count of an association greater than zero
  27. PostgreSQL column ‘foo’ does not exist
  28. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  29. Why are foreign keys more used in theory than in practice?
  30. Drop column from SQLite table

Leave a Comment