Show Databases
SHOW DATABASES; lists every database this user can see. You will also see system ones like mysql, information_schema, performance_schema, sys — don’t DROP those.
SHOW CREATE DATABASE college; shows how it was created (charset). For tables: SHOW TABLES; after USE.
Trap — dropping mysql or information_schema because they ‘look extra’. That breaks the server.
On the example next to this theory: Show Databases — cREATE DATABASE makes a schema; USE selects it for following statements.
Exam tip
SHOW DATABASES; never drop mysql or information_schema.