SQL Server Performance

How do I find all the tables that do not have an index?

Discussion in 'SQL Server Knowledge Sharing Network (SqlServer-qa' started by satya, Sep 5, 2007.

  1. satya Moderator

    SELECT SCHEMA_NAME(schema_id) AS schema_name
    ,name AS table_name
    FROM sys.tables
    WHERE OBJECTPROPERTY(object_id,'IsIndexed') = 0
    ORDER BY schema_name, table_name;

  2. Siddu New Member

    This is simply superb

Share This Page