Preview table contents in the bottom pane where SP previews are shown.
The preview pane under the search results is wasted space when searching for tables.
Tables should be previewed like SPs when highlighted in the search results, either the top n rows, or even just a list of columns in the table would be more useful.
Ross
shared this idea
The new release of SQL Search fixes this problem. you can download it here:
http://www.red-gate.com/products/sql-development/sql-search/v2
Thanks for the suggestion. We are now closing this issue so that votes are reallocated.
Thanks
SQL Search Development Team
-
Stephen
commented
A CREATE script, including a commented out
/* IF EXISTS ...
DROP
*/
using the OBJECT_ID syntax would be great. Use the script options from SSMS for consistency, or the SQL Prompt pop-up style, so, let us choose which style... (if there's a difference, that is!)(First, do no harm!)
-
Ross
commented
@David:
Yes you're right, a CREATE script for the table would be good, it would let you see more than just the columns available, maybe with a checkbox somewhere to instruct it to switch to a preview of the TOP n rows instead, if the user prefers.
Personally, I would find both 'CREATE' and a 'TOP n' previews to be very useful
-
I really like the idea of showing the top n rows, maybe as an option. Regarding a preview of the table structure itself, which would be more useful, a list of columns or the scripted out CREATE SQL for the table?
