TRUNCATE TABLE statement

Use the TRUNCATE TABLE statement to quickly delete all records in the specified table, emptying the table of all data.

Copy

TRUNCATE TABLE table_name

You cannot specify a WHERE clause with the TRUNCATE TABLE statement. The TRUNCATE TABLE statement deletes all records.

Only the records in the table specified by table_name are deleted. Records from any related tables are not affected.

The TRUNCATE TABLE statement needs to be able to lock all records in the table in order to delete the record data. If any record in the table is locked by another user, FileMaker software returns the error code 301 ("Record is in use by another user").