复古 护眼 海天 深邃 暗黑 默认

单表

语法说明

SHOW SINGLE TABLE (tableRule | RULES) [FROM databaseName]

SHOW SINGLE TABLES 

tableRule:
    RULE tableName

返回值说明

Single Table Rule

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

Single Table

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

示例

single table rules

sql> show single table rules;
+---------+---------------+
| name    | resource_name |
+---------+---------------+
| default | ds_1          |
+---------+---------------+
1 row in set (0.01 sec)

single tables

mysql> show single tables;
+--------------+---------------+
| table_name   | resource_name |
+--------------+---------------+
| t_single_0   | ds_0          |
| t_single_1   | ds_1          |
+--------------+---------------+
2 rows in set (0.02 sec)