Check Rows

/*

Check Rows

*/

USE  [App]

GO

SELECT '['+ SCHEMA_NAME(A.schema_id) + '].[' +  A.Name + ']' AS [TABLE]

     , SUM(B.rows) AS 'RowCount'

FROM        sys.objects A

INNER JOIN sys.partitions B ON A.object_id = B.object_id

WHERE       A.type = 'U'

AND SCHEMA_NAME(A.schema_id) = 'pro'

GROUP BY    A.schema_id, A.Name

ORDER BY 2 desc

GO

USE  Staging

GO

SELECT '['+ SCHEMA_NAME(A.schema_id) + '].[' +  A.Name + ']' AS [TABLE]

     , SUM(B.rows) AS 'RowCount'

FROM        sys.objects A

INNER JOIN sys.partitions B ON A.object_id = B.object_id

WHERE       A.type = 'U'

AND SCHEMA_NAME(A.schema_id) = 'DW'

GROUP BY    A.schema_id, A.Name

ORDER BY 2 desc

GO

SELECT '['+ SCHEMA_NAME(A.schema_id) + '].[' +  A.Name + ']' AS [TABLE]

     , SUM(B.rows) AS 'RowCount'

FROM        sys.objects A

INNER JOIN sys.partitions B ON A.object_id = B.object_id

WHERE       A.type = 'U'

AND SCHEMA_NAME(A.schema_id) = 'OTH'

GROUP BY    A.schema_id, A.Name

ORDER BY 2 desc

GO

SELECT '['+ SCHEMA_NAME(A.schema_id) + '].[' +  A.Name + ']' AS [TABLE]

     , SUM(B.rows) AS 'RowCount'

FROM        sys.objects A

INNER JOIN sys.partitions B ON A.object_id = B.object_id

WHERE       A.type = 'U'

AND SCHEMA_NAME(A.schema_id) = 'DBO'

GROUP BY    A.schema_id, A.Name

ORDER BY 2 desc

GO

SELECT '['+ SCHEMA_NAME(A.schema_id) + '].[' +  A.Name + ']' AS [TABLE]

     , SUM(B.rows) AS 'RowCount'

FROM        sys.objects A

INNER JOIN sys.partitions B ON A.object_id = B.object_id

WHERE       A.type = 'U'

AND SCHEMA_NAME(A.schema_id) = 'FLE'

GROUP BY    A.schema_id, A.Name

ORDER BY 2 desc

GO