This article is tagged with:
Sql server information_schema temp tables
and mysql
sql server information_schema temp tables
SELECT
*
FROM
tempdb.INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME LIKE '%XYZ%'
ORDER BY
ORDINAL_POSITION