This tutorial will walk you through how to explore a database and find all columns with a specific word you are looking for. This is very useful when you are new to a data environment and need to learn the relationships between tables.
Github Script:
https://github.com/ProfessorPitch/ProfessorPitch/blob/master/SQL/ColumnSearch.sql