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
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
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
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
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
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.
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
678.414.0090 my cell Primary
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
678.414.0090 my cell Primary
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
678.414.0090 my cell Primary
Hello,
You’re the faster gunman on the wild west, thanks for the quick answer !
Roger
Don’t click data grid on the RHS. Click the table on the LHS instead J .
Igor.
Don’t click data grid on the RHS. Click the table on the LHS instead J .
Igor.
Don’t click data grid on the RHS. Click the table on the LHS instead J .
Igor.
