CAST(case when dtb.name in ('master','model','msdb','tempdb')
   then 1
   else dtb.is_distributor end AS bit) AS [IsSystemObject]

SELECT dtb.name AS [Database_Name]
FROM master.sys.databases AS dtb
WHERE (CAST(case when dtb.name in ('master','model','msdb','tempdb') then 1 else dtb.is_distributor end AS bit)=1)

select * from sys.databases
where owner_sid != 0x01