v.1.1.54362New Feature

Support SHOW CREATE TABLE for Temporary Tables

Official CH changelog text
Support for SHOW CREATE TABLE for temporary tables (zhang2014).
Added support for the SHOW CREATE TABLE command for temporary tables in ClickHouse.

Why it matters

This feature allows users to view the exact DDL (Data Definition Language) statement used to create temporary tables, aiding in debugging, auditing, and replication of table structures during query sessions.

How to use it

Use the SHOW CREATE TABLE [temporary_table_name] command after creating a temporary table to display its creation statement.
PreviousNext