LIST ALL TABLES WITHOUT A CLUSTERED INDEX

select * from sysobjects where xtype = ‘U’ and id not in (select id from sysindexes where indid = 1)

Update me when site is updated

One Comment to “LIST ALL TABLES WITHOUT A CLUSTERED INDEX”

  1. [...] LIST ALL TABLES WITHOUT A CLUSTERED INDEX Start SQL SQL Server Posted by root 2 hours 3 minutes ago (http://www.startsql.com) Apr 3 2009 2009 start sql sql server articles and tutorials powered by wordpress branfordmagazine theme by michael oeser Discuss  |  Bury |  News | LIST ALL TABLES WITHOUT A CLUSTERED INDEX Start SQL SQL Server [...]


Leave a Reply

You must be logged in to post a comment.