Calling all database table names to create a list || pyodbc

I currently have an MSSQL server that has about 60 databases in it.

Does anyone know a way to list the database names with a for loop, so that I am able to access each table?

The structure should be something like this :

for each Database in Server    
  MyList{} = MyList + DatabaseName    
endfor

I can't seem to find any documentation that includes something like this

You can query the sys tables in order to get all the objects in your server.

In order to get all the databases, run the following query:

SELECT name, database_id FROM sys.databases
Back to Top