2.7: Alter

For this challenge, you will learn how to add, drop, and alter columns in a table.

  • Add and drop a column to the table called Manufacturer.

  • Add a column to the table called UPC; it should have a data type of VARCHAR(25).

  • Alter the UPC column so that the data type is TEXT.

  • Drop the UPC column from the table.

To see the solution for this challenge, click on 2.12 Solutions. Then, continue to Part 2.8: Customer Table.

Previous2.6: ReadNext2.8: Customer Table

Last updated