Deleting all records in a table

From InterBase
Jump to: navigation, search

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 EmptyTable is gone forever.