The following shows when dropping the current Database db, the session's current Database is also wiped. A new Database can be set with USE from LIST DATABASES for the current session, and with SET DEFAULT as a default for the current Organization:
db.public/<no-store>#DROPDATABASEdb;+------------+------------+------------+----------------------------------------+|Type|Name|Command|Summary|+============+============+============+========================================+|database|db|DROP|database"db"wassuccessfullydropped|+------------+------------+------------+----------------------------------------+<no-db>/<no-store># LIST DATABASES;+------------+-------------+------------+-------------------------------+|Name|IsDefault|Owner|CreatedAt|+============+=============+============+===============================+|otherdb|false|sysadmin|2024-05-0921:56:57+0000UTC|+------------+-------------+------------+-------------------------------+<no-db>/<no-store># USE DATABASE otherdb;+------------+------------+------------+--------------------------+|Type|Name|Command|Summary|+============+============+============+==========================+|database|otherdb|USE|usingdatabase"otherdb"|+------------+------------+------------+--------------------------+otherdb.public/<no-store>#