November 6, 2008 at 12:07 pm
Comments posted to this topic are about the item The Ultimate PK-Less / CLIDX-Less Table Finder
December 5, 2008 at 8:07 am
Jesse,
Shouldn't (HasPrimarykey=0 OR HasClusteredIndex=0) be
(HasPrimarykey=0 AND HasClusteredIndex=0) ?
Doug
December 5, 2008 at 11:27 am
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.
May 23, 2016 at 4:51 pm
Thanks for the script.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply