🎲 A select query to get queries inside a SQL Server database

select-triggers.sql

SELECT 
    t.name AS TriggerName,
    o.name AS TableName,
    t.type_desc AS TriggerType,
    m.definition AS TriggerDefinition
FROM 
    sys.triggers t
INNER JOIN 
    sys.objects o ON t.parent_id = o.object_id
INNER JOIN 
    sys.sql_modules m ON t.object_id = m.object_id
WHERE 
    o.type = 'U'
    AND m.definition LIKE '%xyz%'
ORDER BY 
    o.name, t.name;