mahi

• Mar 16th, 2006

 

Hi,

U can see the information in 'user_triggers' by giving the statement like

select * from user_triggers where trigger_name='xxx';

Thanks

krishna631

 Profile Answers by krishna631 

• May 31st, 2006

 

Hai,

To know weather the Trigger status is Active/Inactive,

Refer to "all_objects" Table

Select * from all_objects where object_type = 'TRIGGER' and

Object_name='XXX'

Krishna Mohan

Kumar Prateek

• May 4th, 2017

 

To know weather the Trigger status is Active/Inactive AND which trigger is used on which Table,
SELECT T.[name] as TableName, TR.[Name] as TriggerName,
CASE WHEN 1=OBJECTPROPERTY(TR.[id], ExecIsTriggerDisabled)THEN Disabled ELSE Enabled END Status
FROM sysobjects T INNER JOIN sysobjects TR on t.[ID] = TR.parent_obj WHERE (T.xtype = U or T.XType = V)
AND (TR.xtype = TR) ORDER BY T.[name], TR.[name]

Atiqur Rahman

• May 18th, 2017

 

There is a tables called ALL_TRIGGERS which contains column STATUS (ENABLE/DISABLE). This column tells us that whether a trigger is enable or disable. Also current user can modify these values if user have CREATE ANY TRIGGER privilege.