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  

You need to login to post a comment.