Drop Database
DROP DATABASE college; deletes the database and every table inside it. There is no recycle bin. This is why interviews ask you to be scared of DROP.
DROP DATABASE IF EXISTS college; is the script form — no error if it is already gone. Take a dump first if the data matters: mysqldump college > college.sql
Trap: DROP DATABASE on the production name because you meant DROP TABLE. Type the full name slowly. Workbench often asks to confirm — read the name.
On the example next to this theory: Drop Database — cREATE DATABASE makes a schema; USE selects it for following statements.
Exam tip
DROP is permanent. Prefer IF EXISTS. Dump before you drop real data.