select SchemaName = s.name ,TableName = tbl.name ,TriggerName = tr.name from sys.objects tr inner join sys.objects tbl on tr.parent_object_id = tbl.object_id inner join sys.schemas s on tbl.schema_id = s.schema_id where 1=1 and tr.type = 'TR' and tbl.type = 'U' order by SchemaName ,TableName ,TriggerName