AcumaticaSQLQueriesAndFunctions/Triggers.sql

IF OBJECT_ID ('dbo.Triggers','V') IS NOT NULL DROP VIEW dbo.Triggers
GO 
CREATE VIEW dbo.Triggers
AS
SELECT 
    t.name AS TriggerName,
    s.name AS SchemaName,
    p.name AS ParentTableName,
    m.definition AS TriggerDefinition
FROM 
    sys.triggers t
JOIN 
    sys.sql_modules m ON t.object_id = m.object_id
JOIN 
    sys.objects p ON t.parent_id = p.object_id
JOIN 
    sys.schemas s ON p.schema_id = s.schema_id
WHERE 
    t.is_ms_shipped = 0 -- Exclude system triggers