list_tables
Lists tables, views, materialized views and foreign tables accessible to the current read login, showing schema, name and kind with 100 results per page. Filter by exact schema name or page with a cursor.
Instructions
Lists the tables, views, materialized views and foreign tables that the read login may use, with schema, name and kind, 100 per page.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cursor | No | The nextCursor of the previous list_tables page. Omit for the first page. | |
| schema | No | The schema to list, by exact name. Omit for every schema. | |
| database | Yes | The database to run on. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | The result rows, each an array in column order. | |
| columns | Yes | The result columns, in order. | |
| truncated | Yes | True when the row cap, the byte cap or limit cut off more rows. | |
| nextCursor | No | Set when more follow. Pass it as cursor for the next page. |