Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Use Primary Keys for Data Uniqueness

- 19.07.26 - ErcanOPAK

🔑 Primary Keys = Data Uniqueness

Data needs uniqueness. Primary keys identify records. Unique, indexed, essential.

📝 Primary Key Basics

# Single column primary key
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100)
);

# Auto-increment primary key
CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100)
);

# Composite primary key
CREATE TABLE user_roles (
    user_id INT,
    role_id INT,
    PRIMARY KEY (user_id, role_id)
);

# Surrogate key vs Natural key
# Surrogate: Auto-generated id
# Natural: Natural identifying column

# Primary key properties
- Unique
- Not null
- Immutable
- Indexed

# Identity columns
CREATE TABLE orders (
    id INT IDENTITY(1,1) PRIMARY KEY,
    order_date DATE
);

# Sequence (PostgreSQL)
CREATE SEQUENCE user_id_seq;
CREATE TABLE users (
    id INT DEFAULT nextval('user_id_seq') PRIMARY KEY,
    name VARCHAR(100)
);

🎯 Primary Key Best Practices

# Use surrogate keys
id INT PRIMARY KEY AUTO_INCREMENT

# Avoid natural keys
-- Bad: Social Security Number
-- Good: Auto-generated id

# Use BIGINT for large tables
id BIGINT PRIMARY KEY AUTO_INCREMENT

# Choose integer over GUID
-- Integer: Smaller, faster
-- GUID: Unique, distributed

# Add primary key after creation
ALTER TABLE users ADD PRIMARY KEY (id);

# Check primary key
SHOW KEYS FROM users WHERE Key_name = 'PRIMARY';

# Primary key vs Unique key
- Primary Key: One per table, not null
- Unique Key: Multiple, can be null

# Best Practices
- Use auto-increment integer
- Never update primary keys
- Use for foreign key references
- Index automatically created
- Use for joins

💡 Primary Key Tips

  • Use auto-increment integer
  • Never update primary keys
  • Use for foreign key references
  • Index automatically created
  • Choose surrogate over natural

“Primary keys ensure data uniqueness. Identify records, enable joins. Essential for database design.”

— DBA

Related posts:

SQL Server: Fix a Point-in-Time Restore That Silently Fails Because an Earlier Switch to the Simple ...

SQL Server: Fix a Point-in-Time Restore That Silently Fails Because an Earlier Switch to the Simple ...

SQL Server: Fix a Deadlock Graph Showing Two Identical Queries Blocking Each Other Because a Missing...

SQL Server: Fix a Deadlock Graph Showing Two Identical Queries Blocking Each Other Because a Missing...

SQL Server: Fix a Foreign Key Constraint Allowing an Update That Should Have Failed Because It Was C...

SQL Server: Fix a Foreign Key Constraint Allowing an Update That Should Have Failed Because It Was C...

Views: 8

Post navigation

.NET Core: Use Rate Limiting for API Protection
C#: Master Exception Handling with Try-Catch

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com