Skip to main content
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';