database:drop

Drop all tables in a given database.

drupal database:drop [arguments] 
dbd

Argument	Details
database	Database key from settings.php
target	Database target from settings.php

Drop the tables on the database specified on the argument

drupal database:drop \
  <database>