---
title: Explore your schema with SQL
description: When working with InfluxDB’s implementation of SQL, a measurement is structured as a table, and time, fields, and tags are structured as columns.
url: https://docs.influxdata.com/influxdb3/clustered/query-data/sql/explore-schema/
estimated_tokens: 766
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/clustered/query-data/sql/explore-schema/
date: '2025-01-13T07:21:11-07:00'
lastmod: '2025-01-13T07:21:11-07:00'
---

When working with the InfluxDB Clustered SQL implementation
a **bucket** is equivalent to a **database**,
a **measurement** is equivalent to a **table**, and **time**, **fields**, and**tags** are structured as **columns**.

## List measurements in a database

Use `SHOW TABLES` to list measurements in your InfluxDB database.

```sql
SHOW TABLES
```

[](#view-example-output)

View example output

Tables listed with the `table_schema` of `iox` are measurements.
Tables with `system` or `information_schema` table schemas are system tables that
store internal metadata.

|table\_catalog|   table\_schema   |table\_name |table\_type|
|--------------|-------------------|------------|-----------|
|    public    |        iox        |    home    |BASE TABLE |
|    public    |        iox        |    noaa    |BASE TABLE |
|    public    |      system       |  queries   |BASE TABLE |
|    public    |information\_schema|   tables   |   VIEW    |
|    public    |information\_schema|   views    |   VIEW    |
|    public    |information\_schema|  columns   |   VIEW    |
|    public    |information\_schema|df\_settings|   VIEW    |

## List columns in a measurement

Use the `SHOW COLUMNS` statement to view what columns are in a measurement.
Use the `IN` clause to specify the measurement.

```sql
SHOW COLUMNS IN home
```

[](#view-example-output)

View example output

|table\_catalog|table\_schema|table\_name|column\_name|        data\_type         |is\_nullable|
|--------------|-------------|-----------|------------|---------------------------|------------|
|    public    |     iox     |   home    |     co     |           Int64           |    YES     |
|    public    |     iox     |   home    |    hum     |          Float64          |    YES     |
|    public    |     iox     |   home    |    room    |  Dictionary(Int32, Utf8)  |    YES     |
|    public    |     iox     |   home    |    temp    |          Float64          |    YES     |
|    public    |     iox     |   home    |    time    |Timestamp(Nanosecond, None)|     NO     |

[query](/influxdb3/clustered/tags/query/)[sql](/influxdb3/clustered/tags/sql/)
| table_catalog | table_schema | table_name | table_type |
| --- | --- | --- | --- |
| table_catalog | table_schema | table_name | table_type |
| public | iox | home | BASE TABLE |
| public | iox | noaa | BASE TABLE |
| public | system | queries | BASE TABLE |
| public | information_schema | tables | VIEW |
| public | information_schema | views | VIEW |
| public | information_schema | columns | VIEW |
| public | information_schema | df_settings | VIEW |

| table_catalog | table_schema | table_name | column_name | data_type | is_nullable |
| --- | --- | --- | --- | --- | --- |
| table_catalog | table_schema | table_name | column_name | data_type | is_nullable |
| public | iox | home | co | Int64 | YES |
| public | iox | home | hum | Float64 | YES |
| public | iox | home | room | Dictionary(Int32, Utf8) | YES |
| public | iox | home | temp | Float64 | YES |
| public | iox | home | time | Timestamp(Nanosecond, None) | NO |