Show all values in known tables that map a type id to a type name.
Q&A for professional and enthusiast programmers
-- Show types -- Show post history types, post types and vote types. SELECT Coalesce(PT.Id, PHT.Id, VT.Id) As [Id], PT.Name As [Post], PHT.Name As [Revision], VT.Name As [Vote] FROM PostTypes PT FULL OUTER JOIN PostHistoryTypes PHT ON PT.Id = PHT.Id FULL OUTER JOIN VoteTypes VT ON PT.Id = VT.Id OR PHT.Id = VT.Id