Available Xtypes in SQL Server

Select
Name,
'Object Type' = Case
When XType = 'C' Then 'Check Constraint'
When XType = 'D' Then 'Default or Default Constraint'
When XType = 'F' Then 'Foreign Key Constraint'
When XType = 'L' Then 'Log'
When XType = 'FN' Then 'Scalar Function'
When XType = 'IF' Then 'Inlined Table Function'
When XType = 'P' Then 'Stored Procedure'
When XType = 'PK' Then 'Primary Key Constraint'
When XType = 'RF' Then 'Replication Filter Stored Procedure'
When XType = 'S' Then 'System Table'
When XType = 'TF' Then 'Table Function'
When XType = 'TR' Then 'Trigger'
When XType = 'U' Then 'User Table'
When XType = 'UQ' Then 'Unique Constraint'
When XType = 'V' Then 'View'
Else 'Extended Stored Procedure'
End
From SysObjects
Group By Name, XType order by 'object type'