describe_table
Retrieve column definitions for a table or view, showing name, type, and nullable status. Optionally get full details including length, precision, and default values.
Instructions
Return column definitions for a table or view. Prefer inspect_table when you also need constraints or FK relationships. Brief mode returns [{name, type, nullable}]. Full mode adds length, precision, scale, default_src, description. If unsure about column names or types, call this before writing any query or DML — do not guess schema.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database key from list_databases. | |
| table | Yes | Exact table or view name. Automatically uppercased. | |
| brief | No | If true, returns only {name, type, nullable}. Default false returns full column detail. | |
| filter | No | Optional case-insensitive .NET regex to filter by column name. |