DataGrip equivalent to SQL search

Answered

Is there an existing way or extension available that does the same job as SQL search (https://www.red-gate.com/products/sql-development/sql-search/)?

Maybe I haven't looked hard enough but I can't seem to find anything.

I've only recently moved to using DataGrip connecting to a redshift cluster. Using the SQL search extension in SSMS in the past I was able to search an entire database for a specific line of text (tables, views, stored procedures etc.) and I want to do the same in DataGrip.

Specific use case is to search every routine/procedure for a specific line of text.

1
4 comments

Take a look at Search Everywhere action https://www.jetbrains.com/help/datagrip/searching-everywhere.html#search_all (invoked by double Shift press)

0

Hi Vasily, thanks for your reply. Unfortunately this doesn't search through the code within the routines. The closest solution I found is that you can right click on an item and select 'Find Usages' - this will show you which routines that specific item is used in. However I don't know how I could get the same result for a specific line of text as you can with redgates 'SQL Search' extension to SSMS.

0

Jack Elliott,

Could you also try Find in Files action?
Pay attention to search scope:

2

Great vasily chernov - this is exactly what I'm looking for. Thank you for your help!

1

Please sign in to leave a comment.