Describe table
describe_tableRetrieve a table's full schema: columns with types, nullability, primary keys, indexes, foreign keys, CREATE statement, and row count. Understand any table structure before running queries.
Instructions
Describe one table: columns (name, type, nullability, default, primary key), indexes, foreign keys, the CREATE statement, and the row count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name (optionally schema-qualified, e.g. "mydb.users") | |
| connection | No | Named connection to use. Omit when only one connection is configured (or it is named "default"). |