Delete Query SQL Server

Delete Query SQL Server

Hi friends, in this post we will learn about Delete Query SQL Server or you can say Delete Query to Delete existing data rows from SQL server tables. SQL Delete Query can always used with conditions only.

Earlier we had discussed about SQL Update Statement, SQL Select Statement, SQL Insert Statement, Drop Table SQL Server, Rename Table in SQL Server, Create Table SQL Server, Schema In SQL Server, SQL Server Operators, Data Type in SQL Server and Drop-Delete SQL Server Database Using Management Studio or Query.

SQL Delete Statement:

----USE DATABASE IN WHICH WE WANT TO DELETE TABLE----
USE Hightechnology
GO

----DELETE DATA----
DELETE FROM  STUDENT_INFORMATION WHERE ID=1

----SELECT RECORD FROM TABLE FOR CHECK----
SELECT * FROM STUDENT_INFORMATION
GO

SQL Delete through Management Studio:

1. Open SQL Server Management Studio, and connect to SQL Server.

2. Expand Database name > Right click on table, from which you want to Delete data and click on Edit Top 200 Rows.

3. It will open table in editable mode, now we can Delete data rows from table. Right click on row which you want to delete and click on Delete. Once Delete is complete. Close the query window.