SHOW PLACEMENT LABELS

SHOW PLACEMENT LABELS is used to summarize the labels and values that are available for Placement Rules.

Note

This feature is not available on TiDB Serverless clusters.

Synopsis

ShowStmt

ShowStmt ::=
    "SHOW" "PLACEMENT" "LABELS" ShowLikeOrWhere?

Examples

SHOW PLACEMENT LABELS;

+--------+----------------+
| Key    | Values         |
+--------+----------------+
| region | ["us-east-1"]  |
| zone   | ["us-east-1a"] |
+--------+----------------+
2 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also

• Placement Rules in SQL
• SHOW PLACEMENT
• CREATE PLACEMENT POLICY