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

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)
  • 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)
  • Re: Disable relationships
    ... ALTER TABLE DISABLE CONSTRAINTS ALL ... We have a table that indicates the people in the SQL Server 2K ... > painful with the current foreign key relationships we have. ...
    (microsoft.public.sqlserver.programming)
Quantcast