Flush Tables
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
- Initiate a Flush Tables action against one or more stored tables. For more information see Initiating an object operation.
- 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. | |
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
Preview |
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.