Function show_table_schema

scripts/view_db.py:27–33

(table_name)

def show_table_schema(table_name):
    conn = connect()
    cursor = conn.cursor()
    cursor.execute(f"PRAGMA table_info({table_name})")
    columns = cursor.fetchall()
    conn.close()
    return columns


def show_table_data(table_name, limit=10):