> ## 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 TABLE DEVICES

This view returns the list of devices per table in the database.

Note that in this view, specifying the `IN TABLE` table\_name is mandatory.

The output is ordered by the `device_id` column.

The following table lists the output’s columns:

| Column name | Data type     | Description                                 |
| :---------- | :------------ | :------------------------------------------ |
| DEVICE\_ID  | `VARCHAR(32)` | The unique device identifier. Filter column |
| MODULE\_ID  | `INT`         | The identifier of the module                |
| CAPACITY    | `BIGINT`      | Total capacity of the device in bytes       |

For example:

```sql theme={null}
SHOW TABLE DEVICES IN TABLE 'my_table';
```