Here is the quickest way to know the list tables in SQL Server which doesn't have Indexes. This will be very useful when we have large number of tables in our SQL Server database. SELECT DISTINCT so.object_id, so.NAME FROM sys.indexes si INNER JOIN sys.objects SO ON SO.object_id = si.object_id WHERE SO.type = 'U' AND si.index_id = 0 Happy Learning !!!
All about Cloud and Agile learning