DELETE Statement in MS SQL Server

Last Updated : 06 Jun, 2024

The DELETE statement in MS SQL Server deletes specified records from the table.

Syntax

MS SQL Server DELETE statement syntax is:

DELETE FROM table_name
WHERE condition;

Note: Always use the DELETE statement with WHERE clause. The WHERE clause specifies which record(s) need to be deleted. If you exclude the WHERE clause, all records in the table will be deleted.

DELETE Statement in MS SQL Server Examples

Let’s look at some examples of the DELETE statement in MS SQL Server. The MS SQL Server DELETE Statement with examples will help in understanding the concept better.

First, we will create a demo SQL database and table, and use the DELETE statement on it.

Table Student

StudentName	RollNo	City
ABC	1	Jaipur
DEF	2	Delhi
JKL	3	Noida
XYZ	4	Delhi

Delete a single record using DELETE Statement

The following SQL statement deletes a row from “Student” table which has StudentName as ‘ABC’.

DELETE FROM student 
WHERE StudentName = 'ABC';
SELECT * FROM student;

Output

StudentName	RollNo	City
DEF	2	Delhi
JKL	3	Noida
XYZ	4	Delhi

Delete all the records using DELETE statement

It is possible to delete all rows from a table without deleting the table. This means that the table structure, attributes, and indexes are going to be intact.

DELETE FROM student;
SELECT * FROM student;

Output:

StudentName	RollNo	City

SQL SERVER | Conditional Statements

khushboogoyal499

Improve

Article Tags :

Similar Reads

Insert Statement in MS SQL Server

The SQL Server INSERT statement is a fundamental command used to add new rows of data to a table. Whether we are inserting specific values, utilizing default values or copying data from another table. In this guide, weâ€™ll explore various ways to use the Insert statement in MS SQL Server with the hel

4 min read

Select Statement in MS SQL Server

The SELECT statement in SQL Server is a foundational SQL command used for querying and retrieving data from one or more tables within a database. This command allows users to specify which columns and rows to retrieve and apply filters to focus on specific data and perform various operations to mani

4 min read

SQL Server MERGE Statement

SQL Server MERGE statement combines INSERT, UPDATE, and DELETE operations into a single transaction. MERGE in SQL ServerThe MERGE statement in SQL provides a convenient way to perform INSERT, UPDATE, and DELETE operations together, which helps handle the large running databases. But unlike INSERT, U

2 min read

SQL SERVER | Conditional Statements

While loop: In SQL SERVER, while loop can be used in similar manner as any other programming language. A while loop will check the condition first and then execute the block of SQL Statements within it as long as the condition evaluates true. Syntax: WHILE condition BEGIN {...statements...} END; Par

2 min read

SQL DELETE Statement

The SQL DELETE statement is one of the most commonly used commands in SQL (Structured Query Language). It allows you to remove one or more rows from the table depending on the situation. Unlike the DROP statement, which removes the entire table, the DELETE statement removes data (rows) from the tabl

4 min read

Insert Into Select statement in MS SQL Server

The INSERT INTO SELECT statement in SQL Server is a versatile feature that enables you to efficiently copy data from one or more tables into another table. This functionality is essential for tasks such as data transfer, backup creation, and data merging. In this article, We will learn to Insert Int

4 min read

Delete Action in MS SQL Server

Prerequisite - Foreign key in MS SQL Server A column can be inserted in a child table only if it is a part of the parent table in case of a foreign key. The foreign key allows us to perform other actions called Referential Actions. Referential actions allow to update or delete a row in case of the p

2 min read

Delete Database in MS SQL Server

Prerequisite â€“ Introduction of MS SQL Server and Create Database in MS SQL Server System databases can't be deleted, only user databases could be deleted. Data and log files will automatically be deleted from disk with database deletion. To delete a database, the below methods could be used â€“ SQL Se

1 min read

Where clause in MS SQL Server

In this article, where clause will be discussed alongside example. Introduction : To extract the data at times, we need a particular conditions to satisfy. 'where' is a clause used to write the condition in the query. Syntax : select select_list from table_name where condition A example is given bel

1 min read

SQL SELECT IN Statement

The IN operator in SQL is used to compare a column's value against a set of values. It returns TRUE if the column's value matches any of the values in the specified list, and FALSE if there is no match. In this article, we will learn how IN operator works and provide practical examples to help you b

4 min read