• Great script. Thanks.

    I added:

    ORDER BY HeapIndex DESC, t.name

    In that way the ones that I need to work on are at the top of the list. It's not so important if you have a few tables. My current application has nearly 200 and this makes things eaier to spot.

    Great work.

    ATBCharles Kincaid