뭐든지하는 웹개발

--테이블 ROWS수 카운트 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 --테이블별 사이즈를 mb단위로 SELECT TABLE_NAME = CONVERT(VARCHAR(30),MIN(O.NAME)), TABLE_SIZE = CONVERT(INT,LTRIM(STR(SUM(RESERVED)*8.192 / 1024,15,0))), UNIT = 'MB' FROM SYSINDEXES I INNER JOIN SYSOBJECTS O ON O.ID = I.ID WHERE I.INDID IN (0,1, 255) AND O.XTYPE ..