Schema Browser

Discussion:

Schema Browser

unostein

2013-02-05 17:37:45 UTC

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

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

John Dorlon

2013-02-05 18:13:11 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of unostein
Sent: Tuesday, February 05, 2013 11:38 AM
To: ***@yahoogroups.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

unostein

2013-02-05 19:21:41 UTC

Permalink

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

Post by John Dorlon
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
Sent: Tuesday, February 05, 2013 11:38 AM
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

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

John Dorlon

2013-02-05 19:25:58 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of unostein
Sent: Tuesday, February 05, 2013 1:22 PM
To: ***@yahoogroups.com
Subject: [toad] Re: Schema Browser

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

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
Sent: Tuesday, February 05, 2013 11:38 AM
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

unostein

2013-02-05 20:11:04 UTC

Permalink

THX again

Post by John Dorlon
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"
Sent: Tuesday, February 05, 2013 1:22 PM
Subject: [toad] Re: Schema Browser
THX for the reply. I think tha last DDL on table would be very helpfull for DBAs

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
Sent: Tuesday, February 05, 2013 11:38 AM
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