SELECt t.name as tablename,tri.name as triname FROM sysobjects tri ,( select * from sysobjects where xtype='U' ) t where tri.xtype='TR' and tri.parent_obj=t.id order by t.tablename
SELECt t.name as tablename,tri.name as triname FROM sysobjects tri ,( select * from sysobjects where xtype='U' ) t where tri.xtype='TR' and tri.parent_obj=t.id order by t.tablename