Show all values in known tables that map a type id to a type name.
Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
-- Show types -- Show post history types, post types and vote types. SELECT Coalesce(COTRT.Id, CRT.Id, FT.Id, PT.Id, PHT.Id, RTRT.Id, RTT.Id, VT.Id) As [Id], PT.Name As [Post], PHT.Name As [Revision], VT.Name As [Vote], CRT.Name As [Close], COTRT.MarkdownMini As [Off-topic], FT.Name As [Flag], RTT.Name As [Review], RTRT.Name As [Review result] FROM PostTypes PT FULL OUTER JOIN CloseAsOffTopicReasonTypes COTRT ON COTRT.Id = PT.Id FULL OUTER JOIN CloseReasonTypes CRT ON CRT.Id = PT.Id FULL OUTER JOIN FlagTypes FT ON FT.Id = PT.Id FULL OUTER JOIN PostHistoryTypes PHT ON PHT.Id = PT.Id FULL OUTER JOIN VoteTypes VT ON VT.Id = PT.Id OR VT.Id = PHT.Id OR VT.Id = PHT.Id OR VT.Id = CRT.Id FULL OUTER JOIN ReviewTaskResultTypes RTRT ON RTRT.Id = PT.Id OR RTRT.Id = VT.Id FULL OUTER JOIN ReviewTaskTypes RTT ON RTT.Id = PT.Id OR RTRT.Id = RTT.Id ORDER BY Id ASC