Question · SQL and MySQL course · Module 4: Creating tables (DDL)

Changing a column's type

Which ALTER TABLE clause will you use to change the type of an existing column, e.g. widen imie to VARCHAR(120)?

Answer options

  • ADD COLUMN
  • DROP COLUMN
  • SELECT COLUMN
  • MODIFY COLUMN

You can check the correct answer by solving this task in the CodeWorlds game.