From here you can start your analysis. If you are looking for all tables with a key column (or any column)
What tables does a view access? Just use:
The INFORMATION_SCHEMA.COLUMNS view will get a lot of use. This is where I usually start. You can scan column and table names and get a list of related items. Then you can branch out to other views as needed.