ALTER TABLE DISABLE TRIGGERS

Home

4D v15



	ALTER TABLE sql_name {ADD column_definition [PRIMARY KEY] [TRAILING] \| DROP sql_name \| ADD primary_key_definition \| DROP PRIMARY KEY \| ADD foreign_key_definition \| DROP CONSTRAINT sql_name \| [{ENABLE \| DISABLE} REPLICATE] \| [{ENABLE \| DISABLE} LOG] \| [{ENABLE \| DISABLE} AUTO_INCREMENT] \| [{ENABLE \| DISABLE} AUTO_GENERATE] \| [{ENABLE* \| DISABLE} TRIGGERS] \|* SET SCHEMA sql_name}

Description

Originally introduced in 4D v14 R3

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

If you want to handle triggers globally at the database level, you need to use ALTER DATABASE (see ALTER DATABASE DISABLE TRIGGERS).