[DATABASE/SQLSERVER] 테이블별 행 수 구하기

icodebroker SQLSERVER 2024-06-18

■ 테이블별 행 수를 구하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    B.name AS TableName
   ,A.rows AS [RowCount]
FROM dbo.sysindexes A INNER JOIN dbo.sysobjects B ON B.id = A.id
WHERE A.indid < 2
AND   B.xtype = 'U'
ORDER BY B.name;

1

2

3

4

5

6

7

8

9

SELECT

B.name AS TableName

,A.rows AS [RowCount]

FROM dbo.sysindexes A INNER JOIN dbo.sysobjects B ON B.id = A.id

WHERE A.indid < 2

AND B.xtype = 'U'

ORDER BY B.name;