RawTree/docs
BlogDocs
Sign inSign up
Introduction
Get started
AgentsCLIAPI
Concepts
IntroductionResource modelAccess controlIngestion modelRaw tablesDynamic fieldsQueries and resultsStorage and computeAdaptive optimizationSorting keysProjectionsMutationsWorkload schedulingApps, connectors, and transformsSQL workflows
Guides
Overview
Integrations
Reference
Authentication
CLIMCP serverTypeScript SDK
Overview
SQL statementsSELECTEXPLAINDESCRIBERole statementsGrant statementsRow-policy statementsSettings-profile statementsWorkload and resource statementsALTER TABLENamed collectionsKILL MUTATIONCREATE TABLEINSERT ... SELECT
Data TypesFormatsSystem Tables
ClickHouse compatibilityLimitsErrors
ReferenceSQL ReferenceStatements

DESCRIBE

Inspect columns and types with a DESCRIBE query.

DESCRIBE

The Query API accepts a statement that starts with DESCRIBE. Use it to inspect a table's columns and types.

Syntax

DESCRIBE TABLE <table>

Examples

Inspect a system table.

DESCRIBE TABLE system.one

Related

  • System tables
  • SELECT

EXPLAIN

Inspect a query plan through the Query API.

Role statements

CREATE ROLE and DROP ROLE support in the Query API.

On this page

DESCRIBESyntaxExamplesRelated

Cookies

  • Necessary, always on: first-party cookies that keep the site working and help us improve it.
  • Third-party analytics: off unless you accept.