When you delete the database then all records of the database will be deleted.
Syntax:-
DROP DATABASE databaseName
Example:-
Suppose you have 2 databases school_management and employee_management and you want to delete database school_management then use below command
DROP DATABASE school_management
Now, you can check the remaining database list through below command
SHOW DATABASES
Output:-
employee_management