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:

SHOW TABLE DEVICES IN TABLE 'my_table';

SHOW TABLES SHOW INDEXES

⌘I

SQL Specification

SQL Syntax Conventions

Data Types

SQL Functions and Operators

Data Definition Language (DDL) Commands

Data Manipulation Language Commands

Transaction Control Language Commands

Data Query Language

Hints

Managing Users

System Monitoring

System Management

Appendices

SHOW TABLE DEVICES