JZTXT

sqlserver查看所有表的行数

发布时间 2023-03-23 16:43:36作者: 极客船长
SELECT 
    t.NAME AS TableName,
    p.rows AS RowCounts
FROM 
    sys.tables t
INNER JOIN 
    sys.partitions p ON t.object_id = p.OBJECT_ID
WHERE 
    t.is_ms_shipped = 0
    AND p.index_id IN (1,0);