How to find a data warehouse's design diagram? I have a database with lots of tables. I need to quickly find out what data warehouse schema was used. Specifically, looking for the dimensions and fact tables. There does not seem to be a standard naming convention. The database diagram is not showing anything.
You probably need a product that can perform database design reverse engineering.

Having said that, we refrain from giving product advice on dba.stackexchange.com since questions about which tool, library, product or resource you should use quickly become obsolete and often are just about the preferences of the answerer.