Show all values in known tables that map a type id to a type name.
Q&A for experienced flyers, pilots, and builders of drones and model aircraft
-- 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 LEFT JOIN CloseAsOffTopicReasonTypes COTRT ON PT.Id = COTRT.Id LEFT JOIN CloseReasonTypes CRT ON PT.Id = CRT.Id LEFT JOIN FlagTypes FT ON PT.Id = FT.Id LEFT JOIN PostHistoryTypes PHT ON PT.Id = PHT.Id LEFT JOIN VoteTypes VT ON PT.Id = VT.Id LEFT JOIN ReviewTaskResultTypes RTRT ON PT.Id = RTRT.Id LEFT JOIN ReviewTaskTypes RTT ON PT.Id = RTT.Id ORDER BY Id ASC