mport pyodbc
import getpass

pwd = getpass.getpass()

con_args = {
    "driver": "FreeTDS",
    "server": "MyServerHost",
    "port": 1433,
    "uid": "sa",
    "database": "master",
    "pwd": pwd,
}
sql = """
    SELECT *
      FROM information_schema.tables
     ORDER BY table_schema, table_name
"""
with pyodbc.connect(**con_args) as conn:
    cur = conn.cursor()
    cur.execute(sql)
    result = cur.fetchall()

print(result)