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;
   GO
   
   

   satya, Sep 5, 2007

   #2
2. Siddu New Member

   This is simply superb

   Siddu, Nov 19, 2007

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in