Truncating a table

Delete all rows from a table and free the associated storage space, or reserve the storage space for reuse by the table and its indexes.

Reusing the storage space can make storage management more efficient in applications in which a table is periodically emptied and reloaded with new rows.

To truncate a table:

  1. On menu for the HCL OpenAdmin Tool (OAT) for Informix®, click SQL Toolbox > Schema Manager.
  2. In the list, expand the database that contains the table.
  3. Select the table.
  4. On the Actions menu, click Truncate Table.
  5. Optional: Select Reserve the storage space to keep the storage space allocated to the table.
Parent topic: Managing tables and indexes
Copyright© 2018 HCL Technologies Limited