If you want to know the list of all databases on sql server, you can use one of the following query or stored procedure.
To get all user created tables from database.