The SQL DELETE statement is used to delete rows from a table. Generally DELETE statement removes one or more records from a table.
Let's see the Syntax for the SQL DELETE statement:
Here table_name is the table which has to be deleted. The WHERE clause in SQL DELETE statement is optional here.
It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact: