Is it correct that SQL Search does not return hits on schema name?

hansjphansjp Posts: 7 Bronze 1
When I search for all objects across databases with the same schema, say "qi", SQL Search only returns tables, views, stored procedures, etc. when they are referenced! That is: I only realise that a table belongs to a certain schema, when I have, say, a stored procedure selecting from said table. And then, I only get a pointer to the stored procedure, not a fast-click-way to the table in question.

I don't see why this should be, but on the other hand, I don't see what is wrong with my settings either.
Tagged:

Answers

  • RichardLRichardL Posts: 418 Gold 4
    Hi @hansjp

    Thanks for your post. 

    I suppose the thing is that Search is searching for objects that contain the text you put in to the field. At the moment is doesn't do the kind of search you're looking for but please do feel free to make the suggestions for future implementation on our SQL Search Uservoice page in the link below. 

    https://redgate.uservoice.com/forums/101149-sql-search

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
Sign In or Register to comment.