Raising exception during SQLite database connection in Python

Question

Here is my code snippet:-

import sqlite3
database = "sample.db"
def dbConnection(database):
    try:
        connection = sqlite3.connect(database)
        db_cursor = connection.cursor()
        db_cursor.execute("show tables;")
        rows = db_cursor.fetchall()
        for row in rows:
            print row
        connection.close()
    except sqlite3.Error, e:
        print "Error in connection",e
dbConnection("enb.db")

It is raising this exception:-

Error in connection near "show": syntax error

I can't see anything wrong with the syntax as I just want to view the tables in the database. What could be the problem here?Thanks

score 1 · Accepted Answer · edited May 23 '17 at 12:11

1

"SHOW TABLES" is not supported by SQLite. It is valid for other databases such as MySQL.

SQLite sql reference

How to 'show tables' in SQLite

edited May 23 '17 at 12:11

Community

1
1

answered Jul 11 '14 at 07:21

Jeremy Allen

6,434
2
26
31

score 0 · Answer 2 · edited May 23 '17 at 12:29

0

SQLite doesn't support "show" functions. You can use SELECT name FROM sqlite_master where type='table'. I found it from this thread, Android sqlite show tables

edited May 23 '17 at 12:29

Community

1
1

answered Jul 11 '14 at 07:19

Shang

85
7

Raising exception during SQLite database connection in Python

2 Answers2