mysql_describe_table
Retrieve the structure and schema of a MySQL database table to understand column definitions, data types, and constraints for database management and query development.
Instructions
Get the structure/schema of a specific table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (uses current database if not specified) | |
| table | Yes | Table name to describe |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (uses current database if not specified)",
"type": "string"
},
"table": {
"description": "Table name to describe",
"type": "string"
}
},
"required": [
"table"
],
"type": "object"
}