CODE EXAMPLE FOR SQL

sql server information_schema temp tables

SELECT 
	* 
FROM
	tempdb.INFORMATION_SCHEMA.COLUMNS 
WHERE 
	TABLE_NAME LIKE '%XYZ%'
ORDER BY 
	ORDINAL_POSITION