For a table, Table_1, which is set up to trigger code on deleting a record, how can you quickly delete all records from the table while bypassing the trigger? By using the TRUNCATE TABLE command, new as of 4D v11 SQL Release 2:

TRUNCATE TABLE([Table_1])

It is similar to issuing the following commands:

ALL RECORDS([Table_1]) DELETE SELECTION([Table_1])

But TRUNCATE TABLE will not cause the on delete trigger to run. Also note that referential integrity of the data is not checked, so it should be used carefully.