How to check whether a column exists in a particular database (SQL)

If you need to check for a particular column in SQL server but you don't know which table it is in then it can be found with the following query: