Preview Content - log in or Join KEBI Academy

SQL DELETE Statement


In this step by step SQL Tutorial I will show you how to remove rows from a table . For the purpose of this tutorial I will use SQL Server 2012.

Other Versions of SQL Server:

  • SQL Server 2012
    • This blog post has been written using SQL Server 2012
  • SQL Server 2008 / R2
    • The examples we used should work in SQL Server 2008 and R2
  • SQL Server 2005
    • We suspect that this will work in SQL Server 2005 as well

Who is it for?

  • People who would like to learn basics of using SQL DELETE 
  • Those who are preparing for Microsoft certifications and need to cover this topic.

Content:

DELETE Introduction

Delete allows to remove rows from a table and you can write delete query with filters so you delete only the rows you want.

To better understand DELETE let's create a task that is close to real-life. In our story imagine you are a developer
that has been ask to clean your table before loading new data from spreadsheet. In the  following example I will show you how you could solve your task.

DELETE using SSMS 2012

For this example I will use AdventureWorksDW2012 database, dbo.DatabaseLog table. 

To access members only content log in
or join KEBI Academy and unlock your potential

Just $8/month
Silver Membership
View more
7 Days Free Trial
Subscriptions only
View more
Fast Learning
made easy & affordable
View more
214 fellow members joined KEBI Academy
+48 members in last 30 days
Did you find this page useful?

+1  |  -0
(1 Votes)