#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import sqlite3

conn = sqlite3.connect(r'\\ll\D\xtrssvjj\db\dpd.db')
cursor = conn.execute("PRAGMA table_info(ads)")
print("ads 表的字段信息：")
print("-" * 80)
for row in cursor:
    print(f"cid: {row[0]:2d}, name: '{row[1]:<15}', type: {row[2]:<10}, notnull: {row[3]}, default: {row[4]}, pk: {row[5]}")
print("-" * 80)
cursor.close()
conn.close()