Feedback: DROP DATABASE

Page: https://cockroachlabs.com/docs/v25.1/drop-database.html

## What is the reason for your feedback?

[X] Missing the information I need

## Additional details
The doc says ```CASCADE (Default) Drop all tables and views in the database as well as all objects (such as constraints and views) that depend on those tables. CASCADE does not list objects it drops, so should be used cautiously.``` - it however does not mention how to list the objects that are affected by `CASCADE` option.
If I do not use `CASCADE`, what happens to these orphan objects? Is there a way to list them and remove at a later stage?

Request that some note on this is provided.

Jira issue: DOC-12614