Flush Tables

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you build and submit a FLUSH statement, specifying a TABLE or TABLES option. This flushes the specified tables and removes all query results from the query cache.

Platform Availability

To Flush One or More Tables

  1. Initiate a Flush Tables action against one or more stored tables. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in this wizard:
Step Settings and tasks

Action Options

Displays the tables selected for this flush operation.


Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.


Displays the DDL that will execute the object action. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.