Is there a way I could view the list of Site Collection under a specific Content Database?
Doing it one-by-one on Central Admin is not desirable since there's a lot.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityYep!
(Get-SPContentDatabase DatabaseName).Sites
That will output a list of URLs.