where object_id = (select object_id from sys.objects where name = 'TABLENAME')
This query will list all tables without an index:
select * from sys.indexes where object_id = (select object_id from sys.objects where name = 'MYTABLE')
Loading
This query will list all tables without an index:
select * from sys.indexes where object_id = (select object_id from sys.objects where name = 'MYTABLE')
Join the conversation! Your thoughts help the community grow.