How to Delete Data in SQL
You have already learned how to drop a table and a view, and now you’ll learn the SQL Delete statement. DROP and DELETE are two different operations to remove data from a database. The SQL DELETE removes specific rows of data from a table, while DROP removes an entire database object.
Here’s the syntax for the SQL DELETE:
DELETE FROM table_name WHERE condition;
For example, suppose you have a tv_show table, and you want to delete all the records launched after 2000. The SQL statement would be:
DELETE FROM tv_show WHERE year_launch > 2000 ;
Note that it’s recommended to back up the database before executing a DELETE statement, as the SQL DELETE permanently removes data from a table.
An Easier Way to Delete Data
If you are in Coginti, you can right-click the table you want to delete data. The application will generate the code with the proper schema, and you can fulfill the conditions to specify what will be deleted.