sql server中查询所有触发器已经对应的表名称

SELECT ts.name AS 表名,sy.name AS 触发器名 FROM Sysobjects sy JOIN Sysobjects ts ON sy.parent_obj=ts.id
WHERE sy.type='TR'