| 4D v15ALTER DATABASE DISABLE TRIGGERS | ||||||||||||||
| 
 | 
    4D v15
 ALTER DATABASE DISABLE TRIGGERS 
         | |||||||||||||
| ALTER DATABASE {ENABLE | DISABLE} {INDEXES | CONSTRAINTS | TRIGGERS} | ||
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 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
	Product:  4D
	Theme:  4D SQL Server
	
        
        
	
	4D v15 - Upgrade (standard edition) ( 4D v15)
 Add a comment
Add a comment