Skip to main content

What is a Primary Key and why is it important?

Entry MS SQL
Quick Answer A primary key uniquely identifies each row in a table รขโ‚ฌโ€ no two rows can have the same value, and it can't be NULL. It's the anchor for relationships between tables and speeds up lookups. Without it, finding or linking a specific record becomes messy and unreliable.

Answer

A primary key uniquely identifies each row. It ensures uniqueness, improves indexing, and maintains reliable data integrity.

S
SugharaIQ Editorial Team Verified Answer

This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice