adspace


What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

Answer Posted / Avdesh Tripathi

{n "triggers": {n "definition": "Database objects that automatically execute a stored procedure in response to an event",n "purpose": "Triggers enable the automatic enforcement or implementation of business rules, security policies, auditing and logging, and data consistency checks",n "types": [n {"name": "Before trigger", "event": "occurs before an operation is executed"},n {"name": "After trigger", "event": "occurs after an operation is executed"},n {"name": "Instead of trigger", "event": "replaces the default action for a specified event"}n ],n "magic tables": "Special system tables that store information about triggers and other database objects in Sybase ASE"n }

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category