The Ultimate PK-Less / CLIDX-Less Table Finder

Question

Post reply

The Ultimate PK-Less / CLIDX-Less Table Finder

YeshuaAgapao

Hall of Fame

Points: 3495
More actions
November 6, 2008 at 12:07 pm

#195467

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

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

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

Douglas Osborne-456728 SSCommitted Points: 1569 More actions · Answer 1

Jesse,

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

(HasPrimarykey=0 AND HasClusteredIndex=0) ?

Doug

YeshuaAgapao Hall of Fame Points: 3495 More actions · Answer 2

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 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

May 23, 2016 at 4:51 pm

#1880917

Thanks for the script.