Within SQL Server, you can create a join to the following 11 table types. Table types can be schema-bound objects, meaning they are saved as a database object within a named schema, or they are ...

lukaseder changed the title Work around SQL Server's buggy UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables - Merge [#16938] Work around SQL Server's peculiar UNION with ORDER ...

I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?