Identify tables without Indexes in SQL Server Database

— SQL no clustered index – SQL tables missing clustered index – SQL objectproperty

USE AdventureWorksDW;

SELECT   DISTINCT [Table] = object_name(object_id)

FROM     sys.indexes

WHERE    index_id = 0

         AND objectproperty(object_id,’IsUserTable’) = 1

         AND objectproperty(object_id,’IsMSShipped’) = 0

ORDER BY [Table]

GO

/* Results

Table

AdventureWorksDWBuildVersion

DatabaseLog

FactCurrencyRate

FactFinance

FactInternetSales

FactInternetSalesReason

FactResellerSales

FactSalesQuota

ProspectiveBuyer

*/