CREATE VIEW V_SYS_TABLAS_INFO AS
SELECT sysobjects.name AS TABLA
, SUM(CASE WHEN sysindexes.indid<2 THEN rows ELSE 0 END) AS FILAS
, SUM(CASE WHEN sysindexes.indid IN (0,1,255) THEN sysindexes.reserved ELSE 0 END) * 8 AS RESERVADO
, SUM(CASE WHEN sysindexes.indid IN (0,1) THEN sysindexes.dpages
WHEN sysindexes.indid=255 THEN sysindexes.used ELSE 0 END) * 8 AS USADO
, (SUM(CASE WHEN sysindexes.indid IN (0,1,255) THEN sysindexes.reserved-sysindexes.used
ELSE 0 END)*8) AS [NO USADO]
,(SUM(CASE WHEN sysindexes.indid IN (0,1,255) THEN sysindexes.used ELSE 0 END)- SUM(CASE WHEN sysindexes.indid IN (0,1) THEN sysindexes.dpages
WHEN sysindexes.indid=255 THEN sysindexes.used ELSE 0 END))*8 AS index_size
FROM sysobjects
join sysindexes
ON sysobjects.id=sysindexes.id
WHERE xtype='U'
GROUP BY sysobjects.name
Comments