[MS-SQL] 테이블별 ROW COUNT를 SYSTEM 테이블에서 가져오기

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[USP_RECORD_COUNT]
AS
SET NOCOUNT ON
BEGIN

SELECT O.NAME, I.ROWS
FROM SYSINDEXES I
  INNER JOIN SYSOBJECTS O ON I.ID = O.ID
WHERE I.INDID < 2
AND  O.XTYPE = 'U'
ORDER BY O.NAME 

END
SET NOCOUNT OFF