SQL SERVER - TABELAS, LINHAS E COLUNAS

SELECT CONCAT(SC.NAME, '.', TA.NAME) TABELA, 
	FORMAT(SUM(PA.ROWS), 'N0') LINHAS, 
	(SELECT CONCAT(CC.NAME, '; ') FROM SYS.COLUMNS CC WHERE CC.object_id = TA.object_id FOR XML PATH('')) COLUNAS
FROM SYS.TABLES TA
INNER JOIN SYS.PARTITIONS PA ON PA.OBJECT_ID = TA.OBJECT_ID
INNER JOIN SYS.SCHEMAS SC ON TA.SCHEMA_ID = SC.SCHEMA_ID
INNER JOIN SYS.COLUMNS C ON C.OBJECT_ID = TA.OBJECT_ID 
WHERE TA.IS_MS_SHIPPED = 0 AND PA.INDEX_ID IN (1,0)
	AND TA.NAME NOT LIKE '%HIDL%'
GROUP BY SC.NAME,TA.NAME,TA.object_id
ORDER BY SUM(PA.ROWS) DESC