-- 테이블 용량체크하기
SELECT TABLE_NAME = CONVERT(VARCHAR(30), MIN(O.NAME))
, TABLE_SIZE = LTRIM(STR(SUM(RESERVED) * 8192 / 1024.,15,0) + 'KB')
FROM SYSINDEXES I
INNER JOIN SYSOBJECTS O ON (O.ID = I.ID)
WHERE I.INDID IN (0, 1, 255) AND O.XTYPE = 'U'
GROUP BY I.ID
ORDER BY TABLE_NAME ASC
SELECT TABLE_NAME = CONVERT(VARCHAR(30), MIN(O.NAME))
, TABLE_SIZE = LTRIM(STR(SUM(RESERVED) * 8192 / 1024.,15,0) + 'KB')
FROM SYSINDEXES I
INNER JOIN SYSOBJECTS O ON (O.ID = I.ID)
WHERE I.INDID IN (0, 1, 255) AND O.XTYPE = 'U'
GROUP BY I.ID
ORDER BY TABLE_NAME ASC
'공부할것들' 카테고리의 다른 글
| Microsoft Supoort 사이트 (0) | 2008.11.17 |
|---|---|
| Manually uninstall LogMein? (0) | 2008.11.10 |
| 무료 소프트웨어야~ (0) | 2008.08.16 |
| ActiveX 컨트롤러 설치하기 (0) | 2008.08.12 |
| 복합기 토너가격 비교 (0) | 2008.08.08 |