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").