The information does not appear to be in INFORMATION_SCHEMA, but if it is in there somewhere, I would prefer to use it from there.
I do know of this method:
if exists (
select * from dbo.sysobjects
where name = 'MyTrigger'
and OBJECTPROPERTY(id, 'IsTrigger') = 1
But I am not sure whether it works on all SQL Server versions.
So my questions are:
Is the above the "best" way?
Are there any alternative methods?
What are their pros and cons?