Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

The Basics of Creating Tables in SQL

Introduction
5. Question 4
Summary

Instruction

Well done! Just two more exercises!

Exercise

A furniture manufacturer needs a table with information about the pieces of furniture it produces. The table, named furniture, has already been created and contains the columns id, name, and manufactured (a date column). However, it requires some changes.

Make the following alterations to table furniture:

  1. Rename column manufactured to produced_on.
  2. Delete column name.
  3. Add column category, which should contain a text value of up to 32 characters.

Stuck? Here's a hint!

Type:

ALTER TABLE furniture RENAME COLUMN manufactured TO produced_on;
ALTER TABLE furniture DROP COLUMN name;
ALTER TABLE furniture ADD COLUMN category varchar(32);