Complete list of tables without Indexes


List the 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


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: