Dropping a table

Remove a table with its associated indexes and data.

When you remove a table, you also delete the data stored in it and any indexes, constraints, triggers, access privileges, and local synonyms. You also remove all views based on the table and any violations and diagnostics tables associated with it.

To drop 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 Drop Table.
Parent topic: Managing tables and indexes
Copyright© 2018 HCL Technologies Limited