• Regarding the clause "Where indid < 2", if you have a clustered index there will be a row in sysindexes with indid = 1. If you do not have a clustered index, there will be a row in sysindexes = 0.

    From my testing, only the tables with a clustered index (indid = 1) are accurate.

    Gary