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

SQL Constraints

Introduction
Defining columns with DEFAULT
Adding DEFAULT to existing tables
Summary
12. Review

Instruction

Here's the question for you!

Exercise

A rent-a-car company has the following table that stores information about their rental cars:

CREATE TABLE car (
  id integer PRIMARY KEY,
  make varchar(64) DEFAULT 'Ford',
  model varchar(64),
  displacement decimal(3, 1)
);

Your task is to:

  1. Add a default value of 1.8 to the displacement column.
  2. Remove the default value for the make column.