Linked Questions

11 votes
1 answer
4k views

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 ...
Jürgen K.'s user avatar
  • 3,487
-2 votes
1 answer
4k views

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 ...
zeliboba_fett's user avatar
3 votes
1 answer
2k views

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. ...
Ram's user avatar
  • 83
3 votes
1 answer
2k views

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("...
Shan-x's user avatar
  • 1,196
0 votes
1 answer
639 views

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 ...
Christian's user avatar
  • 26.5k
1 vote
0 answers
251 views

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 ...
greyBow's user avatar
  • 1,358
1 vote
0 answers
75 views

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 ?
Arpit138's user avatar
213 votes
11 answers
313k views

How do I get the equivalents of SQLite's interactive shell commands .tables and .dump using the Python sqlite3 API?
noamtm's user avatar
  • 13.1k
22 votes
6 answers
37k views

How can I get the list of all the available tables in sqlite programmatically?
Mahesh Babu's user avatar
  • 3,434
5 votes
1 answer
20k views

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 ...
LinnK's user avatar
  • 395
6 votes
2 answers
6k views

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 ...
Liondancer's user avatar
  • 16.5k
6 votes
1 answer
3k views

How do I list a DB's tables with Python's DB API? Failing that, is there another way to do it? Thanks
user1458476's user avatar
4 votes
2 answers
9k views

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 ...
John Smith's user avatar
2 votes
2 answers
3k views

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. ...
RahulSalvikar's user avatar
0 votes
1 answer
3k views

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: ...
curiousIT's user avatar
  • 165

15 30 50 per page