returns space usage information : sysindexes « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sysindexes
7> SELECT name = CONVERT(CHAR(30), o.name), rows, dpages, o.id, type
8> FROM sysindexes i JOIN sysobjects o ON o.id = i.id
9> WHERE o.id < 100 AND (indid = 0 OR indid = 1)
10> GO

1>
2>








27.30.sysindexes
27.30.1.select FROM sysindexes WHERE id = object_id('HasText')
27.30.2.table sysindexes contains a row for each index and a row for each table without a clustered index.
27.30.3.returns space usage information