Search for column in SCCM Database views

Sometimes is hard to find the proper table or column in the available views.

The easiest way would be to use simple database query to search in the information schema. For Microsoft reference please check the url below. https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql?view=sql-server-2017

SELECT DISTINCT table_name,column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE ('v_%') AND COLUMN_NAME LIKE '%sourcepath%'
SELECT DISTINCT table_name,column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE ('v_%') ORDER BY column_name