Table constraints - PRIMARY KEY
56.3
Exercise

PRIMARY KEY

Write a set of SQL statements together to:

  1. create a new table courses with the following columns, data types and constraints.

    column data type constraint
    courseId INTEGER PRIMARY KEY
    name TEXT NOT NULL
    abbreviation TEXT
  2. add these record rows to the created table courses

    courseId (INTEGER) name (TEXT) abbreviation (TEXT)
    1 Ruby rb
    2 SQL sql