Subject Re: [IBO] how-to empty a table
Author Helen Borrie
At 08:04 AM 22-05-01 -0700, you wrote:
>HI all,
>
>How can I empty (delete all records) in a particular IB6 table using
>IB_WISQL.exe??
>
>Thanks in advance
>Daniel


On the DSQL tab, just process this statement:

DELETE FROM ATABLE

Without a restricting clause, it will just delete everything (provided there are no dependencies).

Cheers,
Helen


All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________