Is it possible to script SQL search and feed the scrip a large number of object names to search for?

Newellaa

Is it possible to script SQL search and feed the scrip a large number of object names to search for? I have a large number of tables to search for and I'd like to avoid searching one at a time.

DustinM

Hello, 

Thank you for your inquiry into SQL Search. 

Currently, SQL Search lacks the ability to allow scripting to look for multiple objects at once. The 'Search field' within SQL Search only allows for 1 word to be used at a time. You can use Wildcards and a few other functions in this field to help narrow the results.

https://documentation.red-gate.com/ss/how-to-search

Best, 

Dustin