SQL Server DELETE Data

In SQL Server database, DELETE statement is used to delete records from the table.

Syntax:

SELECT TOP 1000 [ID]  

      ,[NAME]  

      ,[AGE]  

      ,[SALARY]  

  FROM.[STUDENT]

Use the SQL Server management Studio:

Follow the management studio screenshots given below:

Use the following command:

DELETE FROM [javatpoint].[dbo].[STUDENT]  

      WHERE ID =3;

Here one row is deleted where ID=3. You can verify it:

Output: