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

Data Types in SQL

Introduction
Modifying columns
5. Changing column type – exercise 1
Modifying identities
Modifying sequences
Summary

Instruction

We successfully extended the type of the column.

It's your turn now.

Exercise

The art gallery owner was so happy with our services that he recommended us to a friend who runs an artist agency.

The agency created a table named actor with the following columns: id, first_name, last_name, and country.

The last column can be up to 8 characters long. As it turns out, that's not enough. Change the column country so that it accepts up to 32 characters.

Stuck? Here's a hint!

Syntax reminder:

ALTER TABLE artwork ALTER COLUMN title SET DATA TYPE varchar(128);