Your Ad Here

advanced code snippet search

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
 
Expand | Embed | Plain Text 
  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.