How to list all table containing SQlite database

[Neil'o]

Hello friends,

I had created a project in Asp.net and everything is working fine expect listing of all table which are in my database, as per my project requirements i have to list all tables containing SQlite database. I had searched a lot over internet but can't get any solution. Can anyone help me out with this issue ?

[Praetor]

As per my knowledge if you are using sqlite3 and if you want to get list of all tables then in command-prompt you need to type ".tables" or else to can also use ".schema" to see a complete database including all tables. If you want you can also use LIKE pattern which will restrict the tables for display

[Katty]

If you are running the sqlite3 command-line access program you can type ".tables" to get a list of all tables. Or you can type ".schema" to see the complete database schema including all tables and indices. Either of these commands can be followed by a LIKE pattern that will restrict the tables that are displayed.

[Rover]

I am also facing similar issue where i need to display tables in SQLite database by using some programming language like c or C++ or any scripting language using Ruby/Perl/Python bindings please provide me any code for it. Thanks in Advance.

[Alejandro]

If you want to get access to table then you can do it by using SELECT table name "SQLITE_MASTER" and for your information SQLite database has an SQLITE_MASTER table.If you want to create SQLITE_MASTER then you can create it by using the below code

CREATE TABLE sqlite_master (
  type1 TEXT,
  name1 TEXT,
  tbl_name1 TEXT,
  rootpage1 INTEGER,
  sql1 TEXT
);