.show table

Inspect the column schema for a named table in the current account. Run through the query editor or normal query API with a query scope allowing control commands.

Spec

.show table '<table_name>'

Parameters

• table_name: Table name, supplied as a quoted string.

Return Value

One row per column, with TableName, DatabaseName, ColumnName, and ColumnType string columns. A missing table produces no matching rows.

Example

.show table 'logs'

Use .show tables to list tables, .create table to declare a table, or .create-merge table to add declared columns.