MS Sql Server Tutorials | Examples | Interview Questions Tutorial

MS SQL Server- Delete Data

❮ Previous Next ❯

Open the SSMS.
In Object Explorer, Expand the database folder and then the table folder.
Select the table where you want to make changes and right-click on it. In the pop-up menu, select Script Table as then Delete to and then New Query Editor Window options from the list.
On clicking the New Query Editor Window, we will reach the following query page. Use the Query to update the table:

DELETE FROM [database_name].[dbo].[table_name][WHERE condition];

DELETE FROM University.dbo.STUDENT WHERE ID ='EN19CS301254';

DELETE TOP (top_value) [ PERCENT ]  FROM [database_name].[dbo].[table_name][WHERE conditions];

The table specifies a table from where we want to delete records.
WHERE condition is optional . If conditions are fulfilled, then records will be deleted.
TOP(top_value) is used to delete the top number of rows. For Example, TOP(10) would delete the top 10 rows.
PERCENT is optional used to delete the percentage of top rows.
Example using TOP(top_value):

DELETE TOP(2) FROM University.dbo.student WHERE CGPA=8.0;

DELETE TOP(25)PERCENT FROM University.dbo.student WHERE CGPA>=8.0;

❮ Previous Next ❯