How to list the tables in a SQLite database file that was opened with ATTACH

Question

What SQL can be used to list the tables  and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

Since nobody has mentioned about the official reference of SQLite  I think it may be useful to refer to it under this heading   https   www sqlite org cli html  You can manipulate your database using the commands described in this link  Besides  if you are using Windows OS and do not know where the command shell is  that is in the SQLite s site    https   www sqlite org download html  After downloading it  click sqlite3 exe file to initialize the SQLite command shell  When it is initialized  by default this SQLite session is using an in-memory database  not a file on disk  and so all changes will be lost when the session exits  To use a persistent disk file as the database  enter the   open ex1 db  command immediately after the terminal window starts up   The example above causes the database file named  ex1 db  to be opened and used  and created if it does not previously exist  You might want to use a full pathname to ensure that the file is in the directory that you think it is in  Use forward-slashes as the directory separator character  In other words use  c  work ex1 db   not  c  work ex1 db    To see all tables in the database you have previously chosen  type the command  tables as it is said in the above link   If you work in Windows  I think it might be useful to move this sqlite exe file to same folder with the other Python files  In this way  the Python file writes to and the SQLite shell reads from  db files are in the same path

User · Answer

Via a union all  combine all tables into one list   select name from sqlite master  where type  table   union all   select name  from sqlite temp master  where type  table

User · Answer

I use this query to get it   SELECT name FROM sqlite master WHERE type  table    And to use in iOS   NSString  aStrQuery  NSString stringWithFormat   SELECT name FROM sqlite master WHERE type  table

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

I use this query to get it   SELECT name FROM sqlite master WHERE type  table    And to use in iOS   NSString  aStrQuery  NSString stringWithFormat   SELECT name FROM sqlite master WHERE type  table

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

Use  help to check for available commands    table   This command would show all tables under your current database

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

Via a union all  combine all tables into one list   select name from sqlite master  where type  table   union all   select name  from sqlite temp master  where type  table

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

Try PRAGMA table info table-name   http   www sqlite org pragma html schema

User · Answer

Use  help to check for available commands    table   This command would show all tables under your current database

User · Answer

da to see all databases - one called  main    tables of this database can be seen by   SELECT distinct tbl name from sqlite master order by 1   The attached databases need prefixes you chose with AS in the statement ATTACH e g  aa    bb  cc     so   SELECT distinct tbl name from aa sqlite master order by 1   Note that here you get the views as well  To exclude these add   where type    table   before   order

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

da to see all databases - one called  main    tables of this database can be seen by   SELECT distinct tbl name from sqlite master order by 1   The attached databases need prefixes you chose with AS in the statement ATTACH e g  aa    bb  cc     so   SELECT distinct tbl name from aa sqlite master order by 1   Note that here you get the views as well  To exclude these add   where type    table   before   order

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

Use   import sqlite3  TABLE LIST QUERY    SELECT   FROM sqlite master where type  table

User · Answer

Try PRAGMA table info table-name   http   www sqlite org pragma html schema

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

Via a union all  combine all tables into one list   select name from sqlite master  where type  table   union all   select name  from sqlite temp master  where type  table

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

da to see all databases - one called  main    tables of this database can be seen by   SELECT distinct tbl name from sqlite master order by 1   The attached databases need prefixes you chose with AS in the statement ATTACH e g  aa    bb  cc     so   SELECT distinct tbl name from aa sqlite master order by 1   Note that here you get the views as well  To exclude these add   where type    table   before   order

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

da to see all databases - one called  main    tables of this database can be seen by   SELECT distinct tbl name from sqlite master order by 1   The attached databases need prefixes you chose with AS in the statement ATTACH e g  aa    bb  cc     so   SELECT distinct tbl name from aa sqlite master order by 1   Note that here you get the views as well  To exclude these add   where type    table   before   order

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

Use   import sqlite3  TABLE LIST QUERY    SELECT   FROM sqlite master where type  table

User · Answer

As of the latest versions of SQLite nbsp 3 you can issue    fullschema   to see all of your create statements

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

Use  help to check for available commands    table   This command would show all tables under your current database

User · Answer

According to the documentation  the equivalent of MySQLs  SHOW TABLES  is      The   tables  command is similar to setting list mode then executing   the following query    SELECT name FROM sqlite master   WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master   WHERE type IN   table   view   ORDER BY 1    However  if you are checking if a single table exists  or to get its details   see  LuizGeron answer

User · Answer

Via a union all  combine all tables into one list   select name from sqlite master  where type  table   union all   select name  from sqlite temp master  where type  table

User · Answer

Try PRAGMA table info table-name   http   www sqlite org pragma html schema

User · Answer

As of the latest versions of SQLite nbsp 3 you can issue    fullschema   to see all of your create statements

User · Answer

Use   import sqlite3  TABLE LIST QUERY    SELECT   FROM sqlite master where type  table

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

Use  help to check for available commands    table   This command would show all tables under your current database

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

According to the documentation  the equivalent of MySQLs  SHOW TABLES  is      The   tables  command is similar to setting list mode then executing   the following query    SELECT name FROM sqlite master   WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master   WHERE type IN   table   view   ORDER BY 1    However  if you are checking if a single table exists  or to get its details   see  LuizGeron answer

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

According to the documentation  the equivalent of MySQLs  SHOW TABLES  is      The   tables  command is similar to setting list mode then executing   the following query    SELECT name FROM sqlite master   WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master   WHERE type IN   table   view   ORDER BY 1    However  if you are checking if a single table exists  or to get its details   see  LuizGeron answer

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

The   schema  commando will list available tables and their rows  by showing you the statement used to create said tables    sqlite  create table a  id int  a int  b int   sqlite   schema table a CREATE TABLE table a  id int  a int  b int

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

Try PRAGMA table info table-name   http   www sqlite org pragma html schema

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

Since nobody has mentioned about the official reference of SQLite  I think it may be useful to refer to it under this heading   https   www sqlite org cli html  You can manipulate your database using the commands described in this link  Besides  if you are using Windows OS and do not know where the command shell is  that is in the SQLite s site    https   www sqlite org download html  After downloading it  click sqlite3 exe file to initialize the SQLite command shell  When it is initialized  by default this SQLite session is using an in-memory database  not a file on disk  and so all changes will be lost when the session exits  To use a persistent disk file as the database  enter the   open ex1 db  command immediately after the terminal window starts up   The example above causes the database file named  ex1 db  to be opened and used  and created if it does not previously exist  You might want to use a full pathname to ensure that the file is in the directory that you think it is in  Use forward-slashes as the directory separator character  In other words use  c  work ex1 db   not  c  work ex1 db    To see all tables in the database you have previously chosen  type the command  tables as it is said in the above link   If you work in Windows  I think it might be useful to move this sqlite exe file to same folder with the other Python files  In this way  the Python file writes to and the SQLite shell reads from  db files are in the same path

User · Answer

It appears you need to go through the sqlite master table  like this   SELECT   FROM dbname sqlite master WHERE type  table     And then manually go through each table with a SELECT or similar to look at the rows   The  DUMP and  SCHEMA commands doesn t appear to see the database at all

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

I use this query to get it   SELECT name FROM sqlite master WHERE type  table    And to use in iOS   NSString  aStrQuery  NSString stringWithFormat   SELECT name FROM sqlite master WHERE type  table

User · Answer

As of the latest versions of SQLite nbsp 3 you can issue    fullschema   to see all of your create statements

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

As of the latest versions of SQLite nbsp 3 you can issue    fullschema   to see all of your create statements

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

According to the documentation  the equivalent of MySQLs  SHOW TABLES  is      The   tables  command is similar to setting list mode then executing   the following query    SELECT name FROM sqlite master   WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master   WHERE type IN   table   view   ORDER BY 1    However  if you are checking if a single table exists  or to get its details   see  LuizGeron answer

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

To list the tables you can also do   SELECT name FROM sqlite master WHERE type  table

User · Answer

The easiest way to do this is to open the database directly and use the  dump command  rather than attaching it after invoking the SQLite nbsp 3 shell tool   So     assume your OS command line prompt is    instead of  sqlite3   sqlite3 gt  ATTACH database sqlite as  attached    From your OS command line  open the database directly    sqlite3 database sqlite sqlite3 gt   dump

User · Answer

The  tables  and  schema  helper  functions don t look into ATTACHed databases  they just query the SQLITE MASTER table for the  main  database  Consequently  if you used  ATTACH some file db AS my db    then you need to do  SELECT name FROM my db sqlite master WHERE type  table     Note that temporary tables don t show up with  tables either  you have to list sqlite temp master for that   SELECT name FROM sqlite temp master WHERE type  table

User · Answer

Use   import sqlite3  TABLE LIST QUERY    SELECT   FROM sqlite master where type  table

User · Answer

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

User · Answer

To show all tables  use  SELECT name FROM sqlite master WHERE type    table    To show all rows  I guess you can iterate through all tables and just do a SELECT   on each one  But maybe a DUMP is what you re after

User · Answer

I use this query to get it   SELECT name FROM sqlite master WHERE type  table    And to use in iOS   NSString  aStrQuery  NSString stringWithFormat   SELECT name FROM sqlite master WHERE type  table

User · Answer

Since nobody has mentioned about the official reference of SQLite  I think it may be useful to refer to it under this heading   https   www sqlite org cli html  You can manipulate your database using the commands described in this link  Besides  if you are using Windows OS and do not know where the command shell is  that is in the SQLite s site    https   www sqlite org download html  After downloading it  click sqlite3 exe file to initialize the SQLite command shell  When it is initialized  by default this SQLite session is using an in-memory database  not a file on disk  and so all changes will be lost when the session exits  To use a persistent disk file as the database  enter the   open ex1 db  command immediately after the terminal window starts up   The example above causes the database file named  ex1 db  to be opened and used  and created if it does not previously exist  You might want to use a full pathname to ensure that the file is in the directory that you think it is in  Use forward-slashes as the directory separator character  In other words use  c  work ex1 db   not  c  work ex1 db    To see all tables in the database you have previously chosen  type the command  tables as it is said in the above link   If you work in Windows  I think it might be useful to move this sqlite exe file to same folder with the other Python files  In this way  the Python file writes to and the SQLite shell reads from  db files are in the same path

User · Answer

There is a command available for this on the SQLite command line    tables  PATTERN       List names of tables matching a LIKE pattern   Which converts to the following SQL   SELECT name FROM sqlite master WHERE type IN   table   view   AND name NOT LIKE  sqlite    UNION ALL SELECT name FROM sqlite temp master WHERE type IN   table   view   ORDER BY 1

User · Answer

Since nobody has mentioned about the official reference of SQLite  I think it may be useful to refer to it under this heading   https   www sqlite org cli html  You can manipulate your database using the commands described in this link  Besides  if you are using Windows OS and do not know where the command shell is  that is in the SQLite s site    https   www sqlite org download html  After downloading it  click sqlite3 exe file to initialize the SQLite command shell  When it is initialized  by default this SQLite session is using an in-memory database  not a file on disk  and so all changes will be lost when the session exits  To use a persistent disk file as the database  enter the   open ex1 db  command immediately after the terminal window starts up   The example above causes the database file named  ex1 db  to be opened and used  and created if it does not previously exist  You might want to use a full pathname to ensure that the file is in the directory that you think it is in  Use forward-slashes as the directory separator character  In other words use  c  work ex1 db   not  c  work ex1 db    To see all tables in the database you have previously chosen  type the command  tables as it is said in the above link   If you work in Windows  I think it might be useful to move this sqlite exe file to same folder with the other Python files  In this way  the Python file writes to and the SQLite shell reads from  db files are in the same path

[sql] How to list the tables in a SQLite database file that was opened with ATTACH?

Examples related to sql

Examples related to database

Examples related to sqlite

Examples related to metadata