INFORMATION_SCHEMA

[ptheriault]

Does anyone know which INFORMATION_SCHEMA view would have information on Triggers? I thought it would be ROUTINES but that only has functions and procedures.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SQLDenis]

2005 or 2000 in 2005 you can use sys.triggers

In order to list DDL triggers you need to use parent_id = 0
SELECT * FROM sys.triggers
WHERE parent_id = 0

In order to list DML triggers you need to use parent_id <> 0
SELECT * FROM sys.triggers
WHERE parent_id <> 0

in 2000
you can use sysobjects

select * from sysobjects
where xtype ='tr'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[ptheriault]

Thanks Denis. I knew about sysobjects but I really like using the INFORMATION_SCHEMA views in 2005. I was hoping there would be some information about triggers in one of them.

But I didn't know about sys.triggers.

Thanks

- Paul
- If at first you don't succeed, find out if the loser gets anything.