#!/usr/bin/env python3
"""
查看srts表结构
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

cursor.execute("PRAGMA table_info(srts)")
columns = cursor.fetchall()

print("srts表结构：")
for col in columns:
    print(f"列名: {col[1]}, 类型: {col[2]}")

conn.close()