Delete Statement in SQL Server(TSQL)

 

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:

Then, we delete records whose value is ‘Nurullah ÇAKIR’ in the name column with the help of the script below:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *