RE: Re: Schema Browser

To get that info, we have to join dba_objects with dba_tables in the query that loads the tables.  That resulted in a slow query for some users, so it is an option.  To enable it, click the LHS filter icon (looks like a funnel) and then check "load date created and altered"

From: [email protected] [mailto:[email protected]] On Behalf Of unostein
Sent: Tuesday, February 05, 2013 1:22 PM
To: [email protected]
Subject: [toad] Re: Schema Browser



THX for the reply. I think tha last DDL on table would be very helpfull for DBAs

--- In [email protected]<mailto:toad%40yahoogroups.com>, John Dorlon wrote:
>
> 1) That list on the RHS is shown when zero or more than 1 objects are selected on the LHS. So you can do select multiple on the left (or CTRL+A to select all) or click the "refresh current list" toolbar button on the schema browser (it has the arrows pointing in a circle with a '1' next to it)
>
> 2) No, but you can sort by any of the columns by clicking the column header. If there is some extra info you'd like to see, let me know. You can add any of those columns to the LHS by rt-clicking the column header on the LHS
>
> From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of unostein
> Sent: Tuesday, February 05, 2013 11:38 AM
> To: [email protected]<mailto:toad%40yahoogroups.com>
> Subject: [toad] Schema Browser
>
>
>
> When you first open a schema browser the right side displays a list of objects based on the obj-type selection on the left.
>
> Question: 1) Is there any way to get the RHS to display that list per user request? I only get it when I open a new window
> 2) Can you change/add the column of the RHS of this obj list
>
> Any help would be greatly appreciated
>