Read Table Triggers

MicroStrategy does not read table triggers specifically from a data source, but values can be selected from system tables via freeform SQL with the appropriate access to the warehouse database. The following is an example:

select * from information_schema.triggers

MicroStrategy lists all the triggers defined by DBA in the warehouse, which is executed for as long as the trigger criteria is met. There is no special handling in MicroStrategy.

MicroStrategy can benefit from SQL server triggers that are executed automatically in response to the database object, database, and server events. For example, when creating a metadata in the SQL server database, a trigger can be used to update all related tables when objects have been deleted.