Previous Topic: Revising the Estimated Row Count for a TableNext Topic: Dropping the Default Index Associated with a Table

Modifying Schema, View, Table, and Routine Definitions › Maintaining Tables › Changing the Area of a Table

Changing the Area of a Table

Drop/Add Table

To change the area in which the rows of a table are stored, you must drop the table and redefine it specifying the new area.

Note: For the steps and considerations involved in this process, see 30.5, “Dropping and Recreating a Table”.