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='Tony';
To delete a table instead of the data inside the table, use the DROP TABLE
command:
DROP TABLE people;