SHOW TABLES Query Updated to Include Temporary Tables

Published: November 25, 2025

The SHOW TABLES query now also shows temporary tables. Added temporary tables and the is_temporary column to system.tables (zhang2014).

The SHOW TABLES query now includes temporary tables, and a new is_temporary column has been added to the system.tables system table to indicate whether a table is temporary.

Why it matters

This feature improves visibility of temporary tables by displaying them alongside regular tables in the SHOW TABLES output and allowing users to identify temporary tables programmatically via the is_temporary column in system.tables. It helps manage and monitor temporary tables more effectively.

How to use it

Simply use the SHOW TABLES query to see both permanent and temporary tables listed. To differentiate temporary tables, query system.tables with the is_temporary column, for example:

SELECT name, is_temporary FROM system.tables WHERE database = 'your_database';