Y
Y
Yourmind2019-09-24 14:55:10
Python
Yourmind, 2019-09-24 14:55:10

How to view database structures using pyodbc?

Can't find how to watch?
I connected to my azure database
but I need to see the structure of another database

import pyodbc

    connection = pyodbc.connect(
        'DRIVER={ODBC Driver 17 for SQL Server};SERVER=mysqlserver7.database.windows.net;DATABASE=mySampleDatabase;UID=azureuser;PWD=ХХХ')
    cursor = connection.cursor()

there is a database named AdventureWork
how to view all its tables?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2019-09-24
@tsklab

You can: SQL Query and Management Tools for SQL Server .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question