Toad World® Forums

Object explorer fail


#1

using the object explorer and tried to open the tables branch under a database
and no tables show up. Here are the steps:

Open a script and run it. I don’t know if the script matters but try this one.

SELECT tbl.name ‘table name’, idx.name ‘index name’, idx.index_id, idx.[type],
idx.data_space_ id, idx.[object_ id]
from sys.indexes idx
inner join sys.tables tbl
on idx.[object_ id] = tbl.[object_ id]
where idx.[type] = 2 and idx.data_space_ id = 1 and idx.object_id > 100
order by tbl.name, idx.name

then go to the object explorer and expand the database, then expand the tables.
No tables appear. I can reproduce this.