EduTech & AI 인공지능 & IT관련 소식

MS SQL 전체 테이블의 크기(row count) 수 조회하기 SELECT sc.name +'.'+ ta.name TableName,SUM(pa.rows) RowCntFROM sys.tables taINNER JOIN sys.partitions paON pa.OBJECT_ID = ta.OBJECT_IDINNER JOIN sys.schemas scON ta.schema_id = sc.schema_idWHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)GROUP BY sc.name,ta.nameORDER BY SUM(pa.rows) DESC