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 DELETE to Remove Data from Tables

- 21.06.26 - ErcanOPAK

🗑️ DELETE = Remove Rows

Data needs removal. DELETE removes rows. Be careful — without WHERE, deletes all rows. Use transactions.

📝 Basic DELETE

-- Delete specific row
DELETE FROM users WHERE id = 123;

-- Delete multiple rows
DELETE FROM users WHERE status = 'inactive';

-- Delete all rows (careful!)
DELETE FROM users;

-- Delete with JOIN (PostgreSQL)
DELETE FROM orders o
USING users u
WHERE o.user_id = u.id AND u.status = 'inactive';

-- Delete with RETURNING (PostgreSQL)
DELETE FROM users WHERE id = 123 RETURNING *;

🎯 TRUNCATE (Faster)

-- TRUNCATE (removes all rows, faster than DELETE)
TRUNCATE TABLE users;

-- TRUNCATE with CASCADE (removes related)
TRUNCATE TABLE users CASCADE;

-- TRUNCATE vs DELETE
-- TRUNCATE: Faster, resets identity, no triggers
-- DELETE: Slower, can use WHERE, triggers fire

💡 Safety Tips

  • Always use WHERE (or you’ll delete ALL rows!)
  • Test with SELECT first (see what will be deleted)
  • Use transactions (BEGIN; …; COMMIT;)
  • Backup before mass deletion
  • Consider soft delete (mark as deleted, don’t remove)

“Forgot WHERE, deleted all users. Disaster. Now always backup and test. DELETE is permanent.”

— Database Developer

Related posts:

SQL Server: Why a Query Using TOP Without ORDER BY Returns Different Rows Each Time You Run It

SQL Server: Why a Query Using TOP Without ORDER BY Returns Different Rows Each Time You Run It

Finding Duplicates Instantly in SQL

Finding Duplicates Instantly in SQL

SQL Server: Fix a Columnstore Index That Silently Falls Back to Row-by-Row Inserts Because Rows Arri...

SQL Server: Fix a Columnstore Index That Silently Falls Back to Row-by-Row Inserts Because Rows Arri...

Views: 14

Post navigation

.NET Core: Use Authorization for Access Control
C#: Use Inheritance for Code Reuse

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