BrushBefore Quick revision. Clear recall. Better interviews.

Tag view

#schema-design

Cross-subject tag search for related interview cards.

Clear

Results update as you type. Press / to jump straight into search.

Tagged with schema-design

3 cards

SQL Easy Theory

Primary key vs foreign key

A primary key uniquely identifies a row in its own table, while a foreign key points to a related row in another table.

  • Primary key is table identity
  • Foreign key creates relationship
  • Helps enforce referential integrity
#keys #schema-design #sql

Primary key vs foreign key