[DATABASE/SQLSERVER] 테이블명과 행 수 표시하기

■ 테이블명과 행 수를 표시하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    A.name   AS [TableName]
   ,B.[rows] AS [RowCount]
FROM SYSOBJECTS A
JOIN SYSINDEXES B ON B.id = A.id
WHERE A.xtype ='u'
AND   B.indid < 2
ORDER BY A.name ASC;

SELECT

A.name AS [TableName]

,B.[rows] AS [RowCount]

FROM SYSOBJECTS A

JOIN SYSINDEXES B ON B.id = A.id

WHERE A.xtype ='u'

AND B.indid < 2

ORDER BY A.name ASC;