listTables
listTablesDiscover database tables and views in a schema, filtered by name pattern or type, without returning column details.
Instructions
Enumerate table and view names in a known schema, optionally filtered by name or type. Does not return fields/columns; use describeTable for one object's structure.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| types | No | JDBC table types CSV (default TABLE,VIEW,MATERIALIZED VIEW): TABLE,VIEW,MATERIALIZED VIEW,SYSTEM TABLE,GLOBAL TEMPORARY,LOCAL TEMPORARY,ALIAS,SYNONYM | |
| schema | No | Omit to use JDBC_DEFAULT_SCHEMA or the current schema. | |
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| namePattern | No | JDBC pattern ('%' any, '_' one character). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | No | Table and view entries. |