Cacher is the code snippet organizer for pro developers

DECLARE @ColumnName NVARCHAR(255)
SET @ColumnName='FIRMA_'

SELECT sc.name +'.'+ t.name TableName,
c.name AS column_name,
SUM(pa.rows) RowCnt
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
INNER JOIN sys.partitions pa ON pa.OBJECT_ID = t.OBJECT_ID
INNER JOIN sys.schemas sc ON t.schema_id = sc.schema_id
WHERE c.name LIKE '%'+@ColumnName+'%' AND t.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY sc.name,t.name,c.name
ORDER BY SUM(pa.rows) DESC