The Ultimate PK-Less / CLIDX-Less Table Finder

  • YeshuaAgapao

    Hall of Fame

    Points: 3495

    Comments posted to this topic are about the item The Ultimate PK-Less / CLIDX-Less Table Finder

  • Douglas Osborne-456728

    SSCommitted

    Points: 1569

    Jesse,

    Shouldn't (HasPrimarykey=0 OR HasClusteredIndex=0) be

    (HasPrimarykey=0 AND HasClusteredIndex=0) ?

    Doug

  • YeshuaAgapao

    Hall of Fame

    Points: 3495

    No I wanted to output tables that was missing one or the other or both, not just both. HasPrimarykey+HasClusteredIndex is in the order by so tables missing both will sort to the top. Then tables missing only PKs, then tables missing only clustered indexes.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply