sql server information_schema temp tables code example

Example: sql server information_schema temp tables

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