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 nameData typeDescription
DEVICE_IDVARCHAR(32)The unique device identifier. Filter column
MODULE_IDINTThe identifier of the module
CAPACITYBIGINTTotal capacity of the device in bytes

For example:

SHOW TABLE DEVICES IN TABLE 'my_table';