Redefining, Regenerating, and Deleting Tables › Deleting Tables

Deleting Tables

Delete Definition and Data

To delete a table, select the Delete Table Definition function from the Table Definition screen. The Delete Table Definition function does all of the following:

• Removes the generated map, dialog, and subschema
• Deletes the table definition from the schema, if the table is a stored table
• If the table is stored, erases all the data stored in the table from the database
• Removes the catalog entry for the table

Delete Definition Only

You can choose to delete the table definition without erasing the table data. To perform a definition-only delete, follow these steps:

1. Make sure the Process Standard Area field in the Extended Table Definition screen is set to NO.
2. Select the Delete Table Definition function from the Table Definition screen.

Once you have deleted the table definition, you can delete the table data as follows:

• If there is only one table in the area, run FORMAT to reinitialize the standard area.
• If there is more than one table in the area, use MAINTAIN ASF to erase the table data.