单表

语法说明

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

返回值说明

Single Table Rule

列说明
name规则名称
resource_name数据源名称

Single Table

列说明
table_name单表名称
resource_name单表所在的数据源名称

示例

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)