How to check if triggers and constraints are enabled/disabled?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Esko (Esko_at_discussions.microsoft.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 07:33:01 -0700

Hello,

I can disable and enable triggers and constraints with sql-statements shown
below.

ALTER TABLE mytable NOCHECK CONSTRAINT ALL
ALTER TABLE mytable DISABLE TRIGGER ALL

ALTER TABLE mytable CHECK CONSTRAINT ALL
ALTER TABLE mytable ENABLE TRIGGER ALL

How can I check if triggers and constraints are enabled or disabled?

Thanks
Esko

 

Relevant Pages

  • Re: How to check if triggers and constraints are enabled/disabled?
    ... "Esko" wrote in message ... > I can disable and enable triggers and constraints with sql-statements ... > ALTER TABLE mytable NOCHECK CONSTRAINT ALL ... > How can I check if triggers and constraints are enabled or disabled? ...
    (microsoft.public.sqlserver.programming)
  • Re: Delete query taking long time to execute
    ... I have asked him to do the NOCHECK when the system is offline (No users ... constraints [See ALTER TABLE WITH NOCHECK] to make the DELETE faster. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Creating Not Null contraints in SE
    ... dbschema is failing with -100 errors. ... NOT NULL constraints cannot be 'ADDED' they have to be MODIFIED: ... ALTER TABLE xredit_cards MODIFY (somecolumn some type NOT NULL ... When you dbexport, ...
    (comp.databases.informix)
  • Re: Altering a Large Table
    ... the old one and recreate the triggers, indexes, and constraints. ... Please keep in mind that my own opinions are my own opinions and ... I'm wondering if there is a trick to altering a large table without running ... I'm running the following alter command in dbaccess; ...
    (comp.databases.informix)
  • drop column fails
    ... alter table TE20_AREA ... checked for indexes, constraints, relations ... help because db modification needs to be in a batch job :- ...
    (microsoft.public.sqlserver.server)