1
select
object_name
(id) tablename,
8
*
reserved
/
1024
reserved,
rtrim
(
8
*
dpages
/
1024
)
+
'
Mb
'
used,
8
*
(reserved
-
dpages)
/
1024
unused,
8
*
dpages
/
1024
-
rows
/
1024
*
minlen
/
1024
free,
2
rows,
*
from
sysindexes
3
where
indid
=
1
4
order
by
rows
desc
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)