The Trigger objects in the database contain:
- IDs of the:
- Table
- Trigger
- Database and subject table database
- User who created the trigger
- User who last updated the trigger
- Timestamp for the last update
- Indexes
- Trigger name and:
- Whether the trigger is enabled
- The event that fires the trigger
- The order in which triggers fire
- Default character set
- Creation text and time stamp
- Overflow text, that is, trigger text that exceeds a specified limit
- Fallback tables