Posted By

tvanzele on 04/01/10


Tagged

sql index DMV


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

g8rpal
Tyster


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  

You need to login to post a comment.