Javatpoint Logo
Javatpoint Logo

SQL Server DELETE Data

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

SQL server delete data 1

Syntax:

Use the SQL Server management Studio:

Follow the management studio screenshots given below:

SQL server delete data 2

Use the following command:

SQL server delete data 3

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

Output:

SQL server delete data 4




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA