The backend query to populate the Schema Browser's Table display is as follows. This query can be extracted from the SQL Tracker.
Select t.table_name,user as owner, t.cluster_name,
t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows
, t.temporary, t.table_type, t.table_type_owner, t.nested
, decode(nvl(buffer_pool, 'x') || upper(partitioned) || nvl(iot_type, 'x') || to_char(pct_free), 'xNOx0', 'YES', 'NO') is_External
, t.dropped
, t.initial_extent
from sys.user_all_tables t
where 1=1
order by table_name
If running this query in the Toad Editor and comparing the sort order for table names, it doesn't completely match up with what the Schema Browser displays in the GUI.
For example, running the back end query will show the following order for the two table names given.
A_CHARTER_SCHOOL
A_CHART_SCH
But the Schema Browser will actually display the following order in the GUI
A_CHART_SCH
A_CHARTER_SCHOOL
WORKAROUND: None
STATUS: Waiting for fix in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center