How to use SQL Server sys.objects, sys.colums, sys.all_sql_modules with Billy Thomas ALLJOY Data
As a data analyst you need to understand how SQL Server organizes and stores objects like your tables, views and even the scripts for those tables and views.
At the end of this video you will be able to:
1. Know where SQL Server stores this information.
2. Query a list of systems that start with 'dq_%'.
3. Find all places that the string 'PASS' has been coded into a view.