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

# SHOW SYSTEM VIEWS

This view has a single row for every system view and a short description of its content.

The output is ordered by the `view_name` column.

The following table lists the output’s columns:

| Column name        | Data type       | Description                                                                                  |
| :----------------- | :-------------- | :------------------------------------------------------------------------------------------- |
| `VIEW_NAME`        | `VARCHAR(127)`  | The system view name. A filter column.                                                       |
| `FILTER_COLUMN`    | `VARCHAR(127)`  | The column by which clients can filter the view                                              |
| `IN_PARAM`         | `VARCHAR(20)`   | The object type by which the view can be filtered (`TABLE` \| `INDEX` \| `DEVICE` \| `NULL`) |
| `ORDER_BY_COLUMNS` | `VARCHAR(127)`  | The columns by which the view is ordered                                                     |
| `DESCRIPTION`      | `VARCHAR(1000)` | A short description on the view content                                                      |

The following table lists the available system views and their description:

| view name                 | filter column | IN\_param | ordered by columns       | description                                         |
| :------------------------ | :------------ | :-------- | :----------------------- | :-------------------------------------------------- |
| `show columns`            | `column_name` | `TABLE`   | `table_name,column_name` | show the columns of all the tables in the database  |
| `show constraints`        | `table_name`  | `TABLE`   | `table_name`             | show all the constraints in the database            |
| `show database metrics`   | `metric_name` | `DEVICE`  | `metric_name`            | shows all the database metrics and their values     |
| `show device metrics`     | `metric_name` | `DEVICE`  | `metric_name,device_id`  | show all the devices metrics and their values       |
| `show devices`            | `device_id`   | `--`      | `device_id`              | show all the devices of the database                |
| `show index devices`      | `device_id`   | `INDEX`   | `device_id`              | show all the devices of a specific index            |
| `show indexes`            | `index_name`  | `TABLE`   | `table_name,index_name`  | show all the indexes in the database                |
| `show metric description` | `metric_name` | `--`      | `metric_name`            | show all the database metrics and their description |
| `show module metrics`     | `metric_name` | `--`      | `metric_name,module_id`  | show all the modules metrics and their values       |
| `show modules`            | `Module_role` | `--`      | `Module_role,node_name`  | show all the modules in the cluster                 |
| `show nodes`              | `node_name`   | `--`      | `node_name`              | show all the nodes in the cluster                   |
| `show system views`       | `view_name`   | `--`      | `view_name`              | show this view                                      |
| `show table devices`      | `device_id`   | `TABLE`   | `device_id`              | show the devices of a specific table                |
| `show tables`             | `table_name`  | `--`      | `table_name`             | show all the tables in the database                 |
| `show users`              | `user_name`   | `--`      | `user_name`              | show all the users in the database                  |