Retro Eye care Haitian Deep Dark Default

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

Column Description
type features
name Data source name

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)