How to display all the tables created in sqlite database on python3

Question

import sqlite3
    
conn = sqlite3.connect('boo2.db')
c = conn.cursor()
    
x = c.execute("SELECT * FROM sqlite_master where type='table'")
    
for y in x:
    print(x)

the output is

********************************
<sqlite3.Cursor object at 0x00272DE0>
Process finished with exit code 0
**************************************

But not any tables ... How to get the table names ?

You are printing x not y. change it to print(y)

kylieCatt
– kylieCatt

2015-07-03 14:18:51 +00:00
Commented Jul 3, 2015 at 14:18 — kylieCatt
– kylieCatt, Commented Jul 3, 2015 at 14:18
My Bad ...Thanks a lot Ian for pointing out

confused genius
– confused genius

2015-07-03 14:26:33 +00:00
Commented Jul 3, 2015 at 14:26 — confused genius
– confused genius, Commented Jul 3, 2015 at 14:26

hiro protagonist · Accepted Answer · 2015-07-03 16:47:17Z

3

you need to fetch the results from the query:

import sqlite3

conn = sqlite3.connect('boo2.db')
c = conn.cursor()

x=c.execute("SELECT * FROM sqlite_master where type='table'")

for y in x.fetchall():
    print(y)

answered Jul 3, 2015 at 16:47

hiro protagonist

47.3k17 gold badges93 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to display all the tables created in sqlite database on python3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related