Deleting all records in a table
From InterBase
Go Up to Working with Tables
To delete all rows of data in a table, call a table component’s EmptyTable method at runtime. For SQL tables, this method only succeeds if you have DELETE privileges for the table. For example, the following statement deletes all records in a dataset:
PhoneTable.EmptyTable;
Important:
Data you delete with
Data you delete with
EmptyTable is gone forever.