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

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

Question Posted / neha srivastava

1 Answers
1061 Views
I also Faced
E-Mail Answers

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

Answer / 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