primary constraint combination of columns

  • in " constraint bookauthors_pk primary key (authorid, titleid) "

    in my book, it defines as: to define a constraint of the combination of the columns authorid and titleid

    does it mean that, in any one of the two columns, we can set the same values(in different rows).

    but the combination of the two columns can not be same(in different rows)

  • It means that the combination of the two columns must be unique.

    Jeremy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply