I needed to find out which columns within all tables in the database, contained a specific string of text. I therefore wrote a script to do exactly that 🙂
The code contained in this post can be used to find all tables that contain columns that have “ADDRESS” in the name. It can easily be modified to search for table column names with any specific word.
The SQL Server function in this post can be used to highlight text (while preserving the case) that has been searched for within a web page.