How to tell if RI constraints are enabled

[pdalberth]

Is there a way to query the data dictionary in SQL 7 to see if referential integrity constraints are enabled for insert/update/delete? I know how to do this in EM but haven't been able to find even an information_schema view that contains this information.

Thanks in advance for any help.

 

[hirick]

The following SQL statement will identify every object that has a trigger:

select parent.name, parent.id, trg.name From sysobjects parent Inner Join sysobjects trg on trg.parent_obj=parent.id where trg.xtype='TR' Order by parent.name

The trigger text is in syscomments, but it's not readily readable. You can either script all objects, and look for the triggers, or choose each table with a trigger, right click and select all tasks, manage triggers, and then read the triggers.