Is the following composite Primary key definition correct:
CREATE TABLE Person (
   firstName  VARCHAR(20) PRIMARY KEY,
   lastName   VARCHAR(20) PRIMARY KEY
)
Explanation
Composite primary key is defined as follows:
CREATE TABLE Person (
   firstName  VARCHAR(20),
   lastName   VARCHAR(20),
   PRIMARY KEY(firstName, lastName)
)

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Cosmo
Sign Up Now
or Subscribe for future quizzes