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

Dropping a column

Which statement will you use to remove the opis column from the ksiazki table?

Answer options

  • DELETE COLUMN opis FROM ksiazki;
  • ALTER TABLE ksiazki DROP COLUMN opis;
  • DROP TABLE ksiazki opis;
  • REMOVE opis FROM ksiazki;

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