Toad World® Forums

Quick way to show table data


#1

Hello,

In Toad for sql server 4.6, is there a quick way to browse table data, instead of having to choose the table and do a left click - generate sql - to editor - select statement + F5 ?

Such a long way you know

I’d like to know if it is possible to “create a custom button” or something similar if this option is not available by default.

Thanks in advance ,

Roger

long_way_if_you_wanna_rock_and_roll.png


#2

Hi Roger,
The best place for this is Data tab in Database Explorer. To open Database Explorer choose View Details from context menu on table name in Object Explorer. Then click on Data tab. I hope this is what you really need. See attached snapshot.

You also can change default option to open Database Explorer on each new connection: Tools|Options|Database|Open on New Connection


#3

Hi Roger,
The best place for this is Data tab in Database Explorer. To open Database Explorer choose View Details from context menu on table name in Object Explorer. Then click on Data tab. I hope this is what you really need. See attached snapshot.

You also can change default option to open Database Explorer on each new connection: Tools|Options|Database|Open on New Connection


#4

Great answer ! just what I was searching for, and more !

Thanks,

Roger

On Tue, Jun 1, 2010 at 8:37 AM, {Toad for SQL Server} on behalf of


#5

Hello again… It is possible to have two or more viewers at the same time ?

I’d like to have more than one table/view opened in the “Data” tab at the same time, but everytime I change the selection, the same data changes to the new selected table/view data…

Thanks in advance,

Roger


#6

Sending the 1st table to the Object Details (right click on table on the LHS >
Send To > Object Details) and then opening RHS (right click on table on the LHS

View Details) should allow viewing both tables on the RHS.

Igor.


#7

Igor, ??? I do not see Object Details in 5.0.1… So has this changed from
4.6 and if so how?

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.png


#8

Igor, ??? I do not see Object Details in 5.0.1… So has this changed from
4.6 and if so how?

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg


#9

Igor, ??? I do not see Object Details in 5.0.1… So has this changed from
4.6 and if so how?

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#10

Hello,

You’re the faster gunman on the wild west, thanks for the quick answer !

Roger


#11

Don’t click data grid on the RHS. Click the table on the LHS instead J .

Igor.
image002.jpeg


#12

Don’t click data grid on the RHS. Click the table on the LHS instead J .

Igor.
image001.png


#13

Don’t click data grid on the RHS. Click the table on the LHS instead J .

Igor.
image001.gif