How to delete table values in sql server 2008 example / delete query in sql server

Introduction:

This article is helps to delete table values using sql server in 2008 R2.

Method 1:

DELETE FROM [dbo].[STUDENTDETAILS] WHERE <Search Conditions,,>

GO

Example:

DELETE FROM [dbo].[STUDENTDETAILS] WHERE ID=3

GO

SELECT * FROM STUDENTDETAILS

Method 2:

Step1:

Expand TableàTable àRight ClickàEdit Top 200 Rows

Step2:

Select particular rowàRight Clickàselect Delete optionàclick ok