The DROP statement in SQL deletes tables, views or indexes. To delete a table, use the DROP statement with the argument TABLE-name to specify which table to drop.