Show CREATE TABLE
show_create_tableGet the complete CREATE TABLE statement for a ClickHouse table, including schema, engine, and settings. Use it to inspect or recreate table definitions.
Instructions
Return the full CREATE TABLE statement (schema, engine, settings) for a table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| database | Yes | Database name |