# Quick way to show table data **URL:** \ **Category:** Toad for SQL Server\ **Created:** [May 31, 2010, 9:04am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698 "2010-05-31T09:04:13Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![RogerTr](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@RogerTr](https://forums.toadworld.com/u/RogerTr)\ **Post date:** [May 31, 2010, 9:04am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/1 "2010-05-31T09:04:13Z")
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](https://global.discourse-cdn.com/quest/original/2X/9/90931aacebd1678a81599be2b308214e9123975e.png) ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [June 1, 2010, 1:32am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/2 "2010-06-01T01:32:46Z")
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 ![TSS_data_tab.png](https://global.discourse-cdn.com/quest/original/2X/d/db38ef32c40cba4db99ed8d844f2cedf637e298e.png) ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [June 1, 2010, 1:32am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/3 "2010-06-01T01:32:46Z")
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 ![TSS_data_tab.png](https://global.discourse-cdn.com/quest/original/2X/d/db38ef32c40cba4db99ed8d844f2cedf637e298e.png) ---
**Author:** ![RogerTr](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@RogerTr](https://forums.toadworld.com/u/RogerTr)\ **Post date:** [June 1, 2010, 2:46am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/4 "2010-06-01T02:46:21Z")
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 ---
**Author:** ![RogerTr](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@RogerTr](https://forums.toadworld.com/u/RogerTr)\ **Post date:** [September 21, 2010, 10:41am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/5 "2010-09-21T10:41:28Z")
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 ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [September 21, 2010, 10:41am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/6 "2010-09-21T10:41:28Z")
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. ---
**Author:** ![hfreeman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hfreeman/32/54_2.png) [@hfreeman](https://forums.toadworld.com/u/hfreeman)\ **Post date:** [September 21, 2010, 11:01am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/7 "2010-09-21T11:01:51Z")
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](mailto:hfreeman@msn.com) 678.414.0090 my cell Primary ![image001.png](https://global.discourse-cdn.com/quest/original/2X/5/59fa4f6a753448a11b883314698e155b57a74069.png) ---
**Author:** ![hfreeman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hfreeman/32/54_2.png) [@hfreeman](https://forums.toadworld.com/u/hfreeman)\ **Post date:** [September 21, 2010, 11:01am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/8 "2010-09-21T11:01:51Z")
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](mailto:hfreeman@msn.com) 678.414.0090 my cell Primary ![image002.jpeg](https://global.discourse-cdn.com/quest/original/1X/ca60ef1b55129d126c1774d4371b31a0a5bd7429.jpeg) ---
**Author:** ![hfreeman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hfreeman/32/54_2.png) [@hfreeman](https://forums.toadworld.com/u/hfreeman)\ **Post date:** [September 21, 2010, 11:01am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/9 "2010-09-21T11:01:51Z")
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](mailto:hfreeman@msn.com) 678.414.0090 my cell Primary ![image001.gif](https://global.discourse-cdn.com/quest/original/1X/c419a4884cb60937895dfef6b4b6862a4a679db6.gif) ---
**Author:** ![RogerTr](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@RogerTr](https://forums.toadworld.com/u/RogerTr)\ **Post date:** [September 21, 2010, 11:03am UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/10 "2010-09-21T11:03:36Z")
Hello, You’re the faster gunman on the wild west, thanks for the quick answer ! Roger ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [September 21, 2010, 12:08pm UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/11 "2010-09-21T12:08:52Z")
Don’t click data grid on the RHS. Click the table on the LHS instead J . Igor. ![image002.jpeg](https://global.discourse-cdn.com/quest/original/1X/ca60ef1b55129d126c1774d4371b31a0a5bd7429.jpeg) ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [September 21, 2010, 12:08pm UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/12 "2010-09-21T12:08:52Z")
Don’t click data grid on the RHS. Click the table on the LHS instead J . Igor. ![image001.png](https://global.discourse-cdn.com/quest/original/2X/5/59fa4f6a753448a11b883314698e155b57a74069.png) ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [September 21, 2010, 12:08pm UTC](https://forums.toadworld.com/t/quick-way-to-show-table-data/11698/13 "2010-09-21T12:08:52Z")
Don’t click data grid on the RHS. Click the table on the LHS instead J . Igor. ![image001.gif](https://global.discourse-cdn.com/quest/original/1X/c419a4884cb60937895dfef6b4b6862a4a679db6.gif)