alter_table
Modify MySQL table structure by adding, dropping, modifying, or renaming columns to adapt database schema to changing requirements.
Instructions
Modify an existing table structure
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| operation | Yes | Type of alteration | |
| column | Yes | Column name | |
| definition | No | Column definition for ADD/MODIFY (e.g., 'VARCHAR(255) NOT NULL') | |
| newName | No | New name for RENAME operation | |
| database | No | Database name (optional) |