Single Table

Syntax

  1. SHOW SINGLE TABLE (tableRule | RULES) [FROM schemaName]
  3. SHOW SINGLE TABLES 
  5. tableRule:
  6.     RULE tableName

Return Value Description

Single Table Rule

ColumnDescription
nameRule name
resource_nameData source name

Single Table

ColumnDescription
table_nameSingle table name
resource_nameThe resource name where the single table is located

Example

single table rules

  1. sql> show single table rules;
  2. +---------+---------------+
  3. | name    | resource_name |
  4. +---------+---------------+
  5. | default | ds_1          |
  6. +---------+---------------+
  7. 1 row in set (0.01 sec)

single tables

  1. mysql> show single tables;
  2. +--------------+---------------+
  3. | table_name   | resource_name |
  4. +--------------+---------------+
  5. | t_single_0   | ds_0          |
  6. | t_single_1   | ds_1          |
  7. +--------------+---------------+
  8. 2 rows in set (0.02 sec)