在 pandas.read_sql 中列出 sql 表 [英] List sql tables in pandas.read_sql

问题描述

我想打开一个 SQL 2005 数据库(文件扩展名为 .mdf)，我一直在尝试这样做:

I would like to open an SQL 2005 database (file has extension of .mdf), and I have been trying this as such:

import pandas as pd
import pyodbc

server = 'server_name'
db = 'database_name'

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=' + server + ';DATABASE=' + db + ';Trusted_Connection=yes')

sql = """

SELECT * FROM table_name

"""
df = pd.read_sql(sql, conn)

有没有办法使用 Pandas 或 pyodbc 查询数据库并列出所有表?我几乎没有数据库方面的经验，所以任何帮助都会很棒.

Is there a way to query the database and list all tables using Pandas or pyodbc? I have virtually NO experience in databases, so any help will be great.

推荐答案

import pyodbc as db

import pandas as pd

conn = db.connect("DRIVER={SQL Server}; SERVER=YourServerName; PORT=1433; DATABASE=YourDB; UID=User; PWD=Password;")

cursor = conn.cursor()

cursor.execute('''select * from sys.databases''')

df=pd.DataFrame(cursor.fetchall())

这篇关于在 pandas.read_sql 中列出 sql 表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！