-- DB 정보 ? 1 sp_helpdb 'Database명칭' -- TABLE 용량 ? 1 2 3 4 5 6 7 8 9 10 11 SELECT CONVERT(VARCHAR(30), MIN(o.name)) AS t_name , LTRIM(STR(SUM(reserved) * 8192.0 / 1024.0, 15, 0) + ' KB') AS t_size 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 -- t_name ASC SUM(reserved) * 8192.0 / 1024.0 DESC -- TABLE 건수 ? 1 2 3 4 5 ..