> ## 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.

> Reference and syntax for the SHOW CATALOGS command.

# SHOW CATALOGS

Returns a table with a row for each catalog (i.e., database) defined in the current Firebolt account, with columns containing information as listed below.

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

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SHOW CATALOGS;
```

## Returns

The returned table has the following columns.

| Column name | Data Type | Description |
| :- | :- | :- |
| catalog\_name | TEXT | The name of the catalog. |
| catalog\_owner | TEXT | Current owner of the catalog. Default owner is the user who created the catalog |
| created | TIMESTAMPTZ | Time the catalog was created (UTC) |
| last\_altered | TIMESTAMPTZ | The date and time that the database was last modified (UTC) |
| last\_altered\_by | TEXT | User/principal who edited the catalog |
| ddl | TEXT | Complete DDL of the database. |
| description | TEXT | User provided description of the database |

## Example

The following example shows information about CATALOGS in the account:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SHOW CATALOGS;
```

| catalog\_name | catalog\_owner | created | last\_altered | last\_altered\_by | ddl | description |
| :- | :- | :- | :- | :- | :- | :- |
| AdTechDB\_v4 | firebolt-demo | 2024-09-03 11:48:31.683328+00 | 2024-09-03 11:48:31.683328+00 | firebolt-demo | CREATE DATABASE AdTechDB\_v4 () WITH DESCRIPTION='DB for AdTech' | DB for AdTech |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.