Linked Questions
31 questions linked to/from How can I list the tables in a SQLite database file that was opened with ATTACH?
11 votes
1 answer
4k views
How to get table information in a database (SQLite) [duplicate]
I'm new to SQLite. I'm using it in Eclipse(Java)just in case this is relevant. Now my problem is that i have a *.db file and know nothing about its content. I would like to know which way i can get ...
-2 votes
1 answer
4k views
How do I retrieve all the tables from database? (Android, SQLite) [duplicate]
Possible Duplicate: How do I list the tables in a SQLite database file I am trying to make a simple interface for creating a simple database using Android device. For example, a program for ...
3 votes
1 answer
2k views
How to list the table name from sqlite DB -- Android [duplicate]
I am new to android sqlite. i want to get list of table residing in one particular database. Is this possible in sqlite. Can anyone guide me on this. I searched long time for this, dint get any idea. ...
3 votes
1 answer
2k views
List the tables of the database [duplicate]
I want to list all the tables of a sqlite3 database, but it doesn’t work. Let’s imagine that in ma database I have the following tables : foo1, foo2, foo3, … Then, with this code : cur.execute("...
0 votes
1 answer
639 views
How do I show the table names that exist in a Java SQLite3 database? [duplicate]
In the spirit of test-driven design I want to test whether the tables get properly created in my SQLite3 database. For that purpose I want to list the table names via an SQL query. I created the ...
1 vote
0 answers
251 views
Display all the tables in the current database using SQLite [duplicate]
How can I display display all the tables in the current database using sql? Right now I'm just trying to count the number of tables in the database but what I'd like to do is list out all of the table ...
1 vote
0 answers
75 views
reading sqlite database using java [duplicate]
I have an sqlite database file named sample.db . Now i don't know its table names or in a broad way i don't know what it contains. So is there any way through which i can read its tables ?
213 votes
11 answers
313k views
How do I get a list of tables, the schema, a dump, using the sqlite3 API?
How do I get the equivalents of SQLite's interactive shell commands .tables and .dump using the Python sqlite3 API?
22 votes
6 answers
37k views
How to get list of all the tables in sqlite programmatically
How can I get the list of all the available tables in sqlite programmatically?
5 votes
1 answer
20k views
Show Tables in SQLite Database in Python
I know this is a very basic question but for some reason I can't get past this one error. I'm trying to show/put all the names of the tables in a database (named 'GData.db') into a variable ...
6 votes
2 answers
6k views
table polls_choice has no column named poll_id
I'm on part 2 of the Django tutorial. This is the error I get when try to add a "choice" in Django administration DatabaseError: table polls_choice has no column named poll_id This is what I get when ...
6 votes
1 answer
3k views
Python DB API list tables
How do I list a DB's tables with Python's DB API? Failing that, is there another way to do it? Thanks
4 votes
2 answers
9k views
Avoiding SQL Injection in SQLite3
I'm trying to figure out a good easy way to avoid SQL Injection and so far I've only been able to come up with two ideas: Base64 encode the user input (Don't really want to do this) Use regex to ...
2 votes
2 answers
3k views
How to get table names in sqllite database
I am using cordova + angular js for developing the mobile app. For creating this POC I am using this SQL tutorial. Now I want to fetch tables name from sqllite db. for this I write below code. ...
0 votes
1 answer
3k views
Django issue: relation "django_site" does not exist
I’ve been trying to add a sitemap to my django website lately. While it looked ok on the local server, when it went live it returned the following error: relation "django_site" does not exist LINE 1: ...