SQL Tips #18 - Listing All Tables Without Any Indexes

Tables without any indexes are usually worth a closer look - this query finds them all.

The Query

SELECT name
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasIndex')=0

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags