아미(아름다운미소)

DB 정보, TABLE 용량, 건수 확인 DB 정보 sp_helpdb 'Database명칭' TABLE 용량 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 건수 SELECT o.name , i.rows FROM ..