What are the challenges you face when working across database platforms? Take the survey

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.


  • Options
    RichardLRichardL Posts: 417 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. 


    Kind regards

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