Learn SQL Database Programming

Deleting all the data from a table

If you want to delete all the rows from a table, you can use the DELETE clause without the WHERE clause.

Be very careful with this method since you will be deleting all the rows in a table and once done, they can't be retrieved.

You can execute the following code to delete all the rows from the allstarfull table in the yourschema database:

USE yourschema; DELETE FROM allstarfull; 

The previous code deletes everything from the allstarfull table.