SQL, how to delete data and tables

Apr 2, 2020

Learn how to delete data from a SQL table with DELETE FROM and the WHERE clause, and how to remove an entire table using the DROP TABLE command.

~~~

To remove data from a table, use the DELETE FROM command.

This deletes all rows:

DELETE FROM people;

You can use the WHERE clause to only remove specific rows:

DELETE FROM people WHERE name='Flavio';

To delete a table instead of the data inside the table, use the DROP TABLE command:

DROP TABLE people;

~~~