Keys: Fundamental Constraint

• In the CREATE TABLE statement, use:

  • PRIMARY KEY, UNIQUE

CREATE TABLE MovieStar (

name CHAR(30) PRIMARY KEY,

address VARCHAR(255),

gender CHAR(1));

• Or, list at end of CREATE TABLE

PRIMARY KEY (name)

Previous slide

Next slide

Back to first slide

View graphic version