SHOW TAGS
Introduced or updated: v1.2.863
Lists tag definitions in the current tenant. You can also query tag definitions through the system.tags table.
See also: CREATE TAG, DROP TAG
Syntax
SHOW TAGS [ LIKE '<pattern>' | WHERE <expr> ] [ LIMIT <n> ]
Output Columns
| Column | Description |
|---|---|
name | Tag name |
allowed_values | Permitted values list, or NULL if any value is allowed |
comment | Tag description |
created_on | Creation timestamp |
Examples
Show all tags:
SHOW TAGS;
Filter tags by name pattern:
SHOW TAGS LIKE 'env%';
Filter with a WHERE condition:
SHOW TAGS WHERE comment IS NOT NULL;
Limit results:
SHOW TAGS LIMIT 5;
Equivalent query using the system table:
SELECT * FROM system.tags;