Breaking News: Grepper is joining You.com. Read the official announcement!

sql server count all tables rows

Outstanding Oyster answered on December 5, 2021 Popularity 9/10 Helpfulness 8/10

answer sql server count all tables rows

related sql server get row count of all tables

sql server count all tables rows

Comment

CREATE TABLE #counts
(
    table_name varchar(255),
    row_count int
)

EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
DROP TABLE #counts

Popularity 9/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: count rows sql sql-server

Link to this answer
Share Copy Link

Contributed on Dec 05 2021

Outstanding Oyster

0 Answers Avg Quality 2/10

Closely Related Answers

sql server get row count of all tables

Comment

SELECT 
    t.NAME AS TableName,
    i.name as indexName,
    p.[Rows],
    sum(a.total_pages) as TotalPages, 
    sum(a.used_pages) as UsedPages, 
    sum(a.data_pages) as DataPages,
    (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, 
    (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, 
    (sum(a.data_pages) * 8) / 1024 as DataSpaceMB
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
WHERE 
    t.NAME NOT LIKE 'dt%' AND
    i.OBJECT_ID > 255 AND   
    i.index_id <= 1
GROUP BY 
    t.NAME, i.object_id, i.index_id, i.name, p.[Rows]
ORDER BY 
    object_name(i.object_id)

Popularity 8/10 Helpfulness 7/10 Language sql

Source: stackoverflow.com

Tags: count get

Link to this answer
Share Copy Link

Contributed on Nov 22 2022

Jay

0 Answers Avg Quality 2/10

sql server count all tables rows

Contents

More Related Answers

sql server count all tables rows

Closely Related Answers

sql server get row count of all tables

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.