SHOW RULES USED RESOURCE

Description

The SHOW RULES USED RESOURCE syntax is used to query the rules that use the specified resource in the specified database.

Syntax

showRulesUsedResource ::=
  'SHOW' 'RULES' 'USED' 'RESOURCES' resourceName ('FROM' databaseName)?
resourceName ::=
  IDENTIFIER | STRING
databaseName ::=
  IDENTIFIER

Supplement

• When databaseName is not specified, the default is the currently used DATABASE; if DATABASE is not used, it will prompt No database selected.

Return Value Description

Example

• Query the rules that use the specified resource in the specified database

SHOW RULES USED RESOURCE ds_0 FROM sharding_db;

+----------+--------------+
| type     | name         |
+----------+--------------+
| sharding | t_order      |
| sharding | t_order_item |
+----------+--------------+
2 rows in set (0.00 sec)

• Query the rules that use the specified resource in the current database

SHOW RULES USED RESOURCE ds_0;

+----------+--------------+
| type     | name         |
+----------+--------------+
| sharding | t_order      |
| sharding | t_order_item |
+----------+--------------+
2 rows in set (0.00 sec)