I’m trying to recall an older query I used to easily locate column names in large databases on SQL server.
For example I’m looking for a keyword ‘%specialist%’ to see how many tables it belongs to and what those tables are labeled as so I can write queries from those tables containing the keyword.
I scanned through similar questions but the answers didn’t yield results.
Maybe I don’t have access to all the tables? But I know I have enough access to bring that keyword back for 6-10 different tables or views.
Can any assist me?