Posted By

tvanzele on 04/01/10


sql index DMV

Versions (?)

Who likes this?

2 people have marked this snippet as a favorite


Find tables without a clustered index

 / Published in: SQL

  1. SELECT name
  2. FROM sys.objects
  3. WHERE type = ‘U’
  4. AND object_id NOT IN
  5. (SELECT object_id FROM sys.indexes WHERE index_id = 1)

Report this snippet  


RSS Icon Subscribe to comments
Posted By: on December 6, 2018

the 8 best oil the8best

You need to login to post a comment.