Using system tables I would like to determine what user tables on our machine are nonclustered indexed. 'DBCC Showcontig' gives 'Index ID' values of '0' and '1', 'Index ID = 1' corresponding to clustered index. However, 'Index ID = 0' may be associated with nonclustered indexed table, or to a table with no index at all (as per Enterprise Manager). So, I am looking for additional information that may be stored in some system table to distinguish between nonclustered indexed tables and tables with no index at all. aijaz90
select * from sysindexes where indid >1 --- which returns list of Non-clustered indexes. Also SP_HELPINDEX will give you list of indexes for a table. Refer to books online for more information. Also refer to this link http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=597&lngWId=5] HTH Satya SKJ
