Skip to main content

SHOW TABLE_FUNCTIONS

Shows the list of supported table functions currently.

Syntax

SHOW TABLE_FUNCTIONS  [LIKE 'pattern' | WHERE expr]

Example

SHOW TABLE_FUNCTIONS;
+------------------------+
| name |
+------------------------+
| numbers |
| numbers_mt |
| numbers_local |
| fuse_snapshot |
| fuse_segment |
| fuse_block |
| fuse_statistic |
| clustering_information |
| sync_crash_me |
| async_crash_me |
| infer_schema |
+------------------------+

Showing the table functions begin with "number":

SHOW TABLE_FUNCTIONS LIKE 'number%';
+---------------+
| name |
+---------------+
| numbers |
| numbers_mt |
| numbers_local |
+---------------+

Showing the table functions begin with "number" with WHERE:

SHOW TABLE_FUNCTIONS WHERE name LIKE 'number%';
+---------------+
| name |
+---------------+
| numbers |
| numbers_mt |
| numbers_local |
+---------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today