List All Tables Without An Index In Your SQL Server Database

To find tables with their creation and modification dates, that don't have an index.

select name As TableName,create_date as DateCreated, modify_date as DateModified
from sys.tables
where objectpropertyex(object_id,'TableHasIndex') = 1