list_tables
Lists tables and views visible to a database profile's login, including schema, type, row counts, size, and read access, so you can pick a table before describing its schema or querying.
Instructions
Tables and views visible to the profile's login in a database: schema, name, type, estimated rows, size and whether the login can read them. Start here, then describe_table, then query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filter | No | name pattern: plain text matches anywhere in the name, or a LIKE pattern with % | |
| schema | No | only this schema | |
| profile | Yes | profile name from list_profiles | |
| database | No | database name from list_databases; default: the profile's |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| columns | Yes | ||
| truncated | Yes |