Alter Table

Uses TEMP table copy strategy for all alterations

• Ignores Foreign Key constraints

Add, delete, re-order, rename, or copy columns

• "rename" can include changing data type, constraints

SQL for changes is shown before exsecution, for verification or modification

Complex modifications can take multiple executions (simple, verifiable logic)

Slightly clunky and not necessarily intuitive, but

• Instructions always there for next step
• Unavailable functions have keys greyed out