> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/metadata/show-tables",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference and syntax for the SHOW TABLES command.

# SHOW TABLES

Returns a table with a row for each table in the current database, with columns containing information for each table as listed below.

For more information regarding tables, see [information\_schema.tables](/reference-sql/information-schema/tables).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW TABLES;
```

## Returns

The returned table has the following columns.

| Column name         | Data Type | Description                                                                                  |
| :------------------ | :-------- | :------------------------------------------------------------------------------------------- |
| table\_name         | TEXT      | The name of the table.                                                                       |
| table\_type         | TEXT      | The table's type, such as `BASE TABLE`, `EXTERNAL` `VIEW`.                                   |
| column\_count       | BIGINT    | The number of columns in the table.                                                          |
| primary\_index      | TEXT      | An ordered array of the column names comprising the primary index definition, if applicable. |
| schema              | TEXT      | The text of the SQL statement that created the table.                                        |
| number\_of\_rows    | TEXT      | The number of rows in the table.                                                             |
| size\_compressed    | TEXT      | The compressed size of the table in human readable format.                                   |
| size\_uncompressed  | TEXT      | The uncompressed size of the table in human readable format.                                 |
| compression\_ratio  | DECIMAL   | The compression ratio (`<size_uncompressed>`/`<size>`).                                      |
| number\_of\_tablets | INTEGER   | The number of tablets that comprise the table.                                               |