SQL Server统计表的行数

Use DB_Name

GO

 

SELECT

    schema_name=SCHEMA_NAME(tb.schema_id)

    ,table_name =OBJECT_NAME(tb.object_id)

    ,row_count =SUM(CASEWHEN ps.index_id < 2 THEN ps.row_count ELSE 0 END)

FROMsys.dm_db_partition_statsas ps WITH(NOLOCK)

    INNERJOINsys.tablesas tb WITH(NOLOCK)

    ON ps.object_id= tb.object_id

WHERE tb.is_ms_shipped = 0

GROUPBY tb.object_id,tb.schema_id

ORDERBYschema_name,table_name