ALTER DATABASE DISABLE TRIGGERS

Home

4D v15



	ALTER DATABASE {ENABLE \| DISABLE} {INDEXES \| CONSTRAINTS \| TRIGGERS}

Description

Originally introduced in 4D v14 R3

The ALTER DATABASE command now allows you to disable or enable triggers for all the tables of the current database for the current session (i.e., for all users and processes until the database is restarted).

If you want to handle triggers at the table level, you need to use ALTER TABLE (see ALTER TABLE DISABLE TRIGGERS).

Example

Example of an import with temporary disabling of all SQL options:

 Begin SQL

    ALTER DATABASE DISABLE INDEXES;

    ALTER DATABASE DISABLE CONSTRAINTS;

    ALTER DATABASE DISABLE TRIGGERS;

 End SQL

 SQL EXECUTE SCRIPT("C:\\Exported_data\\Export.sql";SQL On error continue)

 Begin SQL

    ALTER DATABASE ENABLE INDEXES;

    ALTER DATABASE ENABLE CONSTRAINTS;

    ALTER DATABASE ENABLE TRIGGERS;

 End SQL