query to find a database used in views, macros ,SP etc

Database
Enthusiast

query to find a database used in views, macros ,SP etc

Hi fellow members

Can anyone help in sharing ideas,hints or precise query to find the list of all views (or macro,SP) who are using a particular database in its code ?