4. Adding, Changing or Dropping Columns

Question 1

Which statement will allow you to add a new column to an existing table?

Answer 1

ALTER TABLE tablename

ADD COLUMN columnname datatype;

Question 2

Which statement will delete a column from a table?

Answer 2

ALTER TABLE table

DROP COLUMN columnname;

Question 3

When creating a new column in a table, the …… COLUMN keyword is to be included in the ALTER TABLE statement.

Answer 3

ADD

Question 4

The ALTER TABLE statement allows a user to?

Answer 4

Add, modify and remove columns to a table