Proposal of modification (elimination of small tables):

SELECT

s.name

, t.name

, p.rows

FROM

sys.tables t

JOIN

sys.schemas...

Is it a good idea to add column "is_disabled" from sys.indexes to row set ?

Your correction: SUBSTRING('+-',INDEX_COLUMN_DATA_KEY_COLS.is_descending_key+1,1)

eliminates both problems I found

thx

grzegorz.mozejko (6/16/2014)

---

very usefull, thx

a small correction, when name of first index column is begining part of second index column (add comma):

...

very usefull, thx

a small correction, when name of first index column is begining part of second index column (add comma):

...