Complete list of tables without Indexes

Below query will help you to list all the tables in the database whihc doesn't have indexes

This is query will be usefull when you face performance issue..

select schema_name (schema_id) as [Schema Name], name as [Table Name]
from sys.tables
where objectproperty (object_id, 'IsIndexed')=0
order by 1,2