How do you drop a column from a table (DDL)? Asked in the first-round screen stage.
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| first_name | VARCHAR(100) | Employee first name |
| middle_name | VARCHAR(100) | Employee middle name |
| last_name | VARCHAR(100) | Employee last name |
| hire_date | DATE | Hire date |