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

Community · Accepted Answer · 2017-05-23 12:11:02Z

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, 2017 at 12:11

CommunityBot

11 silver badge

answered Jul 11, 2014 at 7:21

Jeremy Allen

6,6742 gold badges28 silver badges31 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:29:28Z

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, 2017 at 12:29

CommunityBot

11 silver badge

answered Jul 11, 2014 at 7:19

Shang

758 bronze badges

Collectives™ on Stack Overflow

Raising exception during SQLite database connection in Python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related