Thank this author by sharing:
By Teshome Asfaw,
This script is used to find tables without primary key, clustered index and no index in an instance.
Copy the script and paste into query analyer. The output will be DatabaseName, TableName and Missing Index.
Clustered Index and Nonclustered Index
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.