Triggers associated with a table?

[Mayoor]

I would like to know if there are any triggers associated with a table.... is there anyway of doing this please?

 

[gmmastros]

sp_helptrigger '<tablename>'

ex

Assuming you have a table named tektips...

sp_helptrigger 'tektips'



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

select object_name(id) as triggername,object_name(parent_obj) as Tablename
from sysobjects where xtype ='tr'
and object_name(parent_obj) ='TableName'

just replace TableName with your tablename

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[druer]

If you are in Enterprise Manager just right click on the table and choose Manage Triggers. (So many options to choose from.)