Primary Keys – SQL

👨 Dipak Pulami Magar 🗓️ Nov 27, 2025

Creating Primary Keys From Multiple Fields

CREATE TABLE Teacher(
    teacher_id INT NOT NULL,
    subject_id INT NOT NULL,
    dept_id INT NOT NULL,
    PRIMARY KEY (subject_id, dept_id)
);