Harri Jaakkonen Cloudpartner MVP Microsoft MVP Fortytwo fortytwo.io
❯ Entra ID· Zero Trust· Sentinel· Defender· Azure Security ▋
./blog › How to display only user databases in SQL
PS HarriJaakkonen :~/Blog/Posts> cat ./how-to-display-only-user-databases-in.html

How to display only user databases in SQL

09/05/2014 · 1 min read · Post #93
Onpremise
This is how:

select * from sys.sysdatabases where dbid>4 and not like '$'