SELECT * FROM sys.Types WHERE is_user_defined = 1

SELECT * FROM SysTypes WHERE xusertype > 256

select * from sys.databases

select * from sys.databases where name not in('master','model','msdb','tempdb')

SELECT * FROM sys.Types
WHERE (system_type_id <> user_type_id)
AND is_user_defined = 0.