Define primary key

sql

CREATE TABLE departments (
  department_id INTEGER PRIMARY KEY,
  name VARCHAR(100) NOT NULL
);

Explanation

Primary keys uniquely identify each row.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Constraints and Indexes

Ensure a column or column set stays unique.

Open In sheetsqlsame section

Restrict column values with a boolean rule.

Open In sheetsqlsame section

Add an index to improve lookup performance.

Open In sheetsqlsame section

Index multiple columns together.

Open In sheetsqlsame section

Attach a foreign key or check constraint after table creation.

Open In sheetsql1 tag match

Define a new table with columns and constraints.