describe_table
Inspect a table or view's columns, primary and foreign keys, indexes, and estimated row count before writing queries to verify column names and structure.
Instructions
Columns (type, nullable, default), primary key, foreign keys with the referenced table, indexes and estimated rows of one table or view. Use it before writing a query, so column names are right.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | table or view: schema.name, or name in the default 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 |
|---|---|---|---|
| name | Yes | ||
| type | Yes | ||
| schema | Yes | ||
| columns | Yes | ||
| indexes | Yes | ||
| primary_key | Yes | ||
| foreign_keys | Yes | ||
| estimated_rows | No |