I need help creating an MSSQL query to pass in every table name to the query below, which returns the number of rows.
This is how I get the row count for a single table:
SELECT Total_Rows = SUM(st.row_count) FROM sys.dm_db_partition_stats st WHERE object_name(object_id) = 'TABLE_NAME' AND (index_id < 2)
What is the way to loop this query on all tables, returning an output of each table's name and row count?
TableName RowCount --------------------- FirstTable 109 SecondTable 2195 ThirdTable 0