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

# System Catalogs

CockroachDB includes a set of system catalogs that provide non-stored data to client applications.

The following system catalogs are available as schemas preloaded to every database:

* [`information_schema`](https://docs.cockroachlabs.com/docs/v24.2/information-schema), a schema provided for compatibility with the SQL standard.
* [`crdb_internal`](https://docs.cockroachlabs.com/docs/v24.2/crdb-internal), a schema with information about CockroachDB internals.
* [`pg_catalog`](https://docs.cockroachlabs.com/docs/v24.2/pg-catalog),  a schema provided for compatibility with PostgreSQL.
* [`pg_extension`](https://docs.cockroachlabs.com/docs/v24.2/pg-extension), a schema catalog with information about CockroachDB extensions.

> [!CAUTION]
>
> Tables in the system catalogs have varying levels of stability. Not all system catalog tables are meant for programmatic purposes. For more information, see [API Support Policy](https://docs.cockroachlabs.com/docs/v24.2/api-support-policy).

To see all of the system catalogs for the [current database](https://docs.cockroachlabs.com/docs/v24.2/sql-name-resolution#current-database), you can use a [`SHOW SCHEMAS`](https://docs.cockroachlabs.com/docs/v24.2/show-schemas) statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW SCHEMAS;
```

```
     schema_name     | owner
---------------------+--------
  crdb_internal      | NULL
  information_schema | NULL
  pg_catalog         | NULL
  pg_extension       | NULL
  public             | admin
(5 rows)
```

## See also

* [`SHOW`](https://docs.cockroachlabs.com/docs/v24.2/show-vars)
* [`SHOW SCHEMAS`](https://docs.cockroachlabs.com/docs/v24.2/show-schemas)
* [SQL Name Resolution](https://docs.cockroachlabs.com/docs/v24.2/sql-name-resolution)