Session Ready
Exercise

Change types with ALTER COLUMN

The syntax for changing the data type of a column is straightforward. The following code changes the data type of the column_name column in table_name to varchar(10): 

ALTER TABLE table_name
ALTER COLUMN column_name
TYPE varchar(10)

Now it's time to start adding constraints to your database.

Instructions 1/3
undefined XP
  • 1

    Have a look at the distinct university_shortname values in the professors table and take note of the length of the strings.

    • 2

      Now specify a fixed-length character type with the correct length for university_shortname.

    • 3

      Change the type of the firstname column to varchar(64).