With the Delete Statement, we can delete records in a table in the database. The most important thing to note when running this command is to specify the Where condition correctly. If we run the Delete command without specifying the condition, all the records in the table are deleted.
First, we are creating a table and inserting some data into it for using in our test:
|
1 2 3 4 5 6 |
Use [TestDB] GO CREATE TABLE [dbo].[MyTable] (Name VARCHAR(25)) GO INSERT INTO [dbo].[MyTable] VALUES ('Nurullah CAKIR'),('Faruk ERDEM') |
Then, we delete records whose value is ‘Nurullah ÇAKIR’ in the name column with the help of the script below:
|
1 2 3 4 5 6 7 8 |
USE [TestDB] GO SELECT * FROM [TestDB].[dbo].[MyTable] GO DELETE FROM [dbo].[MyTable] WHERE [Name]='Nurullah ÇAKIR' GO SELECT * FROM [TestDB].[dbo].[MyTable] |
