How to List the Tables in a Sqlite Database File That Was Opened With Attach

How can I list the tables in a SQLite database file that was opened with ATTACH?

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';

How to get list of all the tables in sqlite programmatically

try this :

SELECT * FROM sqlite_master where type='table';

List all tables in a DB using SQLite

Try this:

SELECT * FROM sqlite_master WHERE type='table'

How to access attached database's tables using python's sqlite3?

db_2_name's value is a string that is the alias of the attached database.

You should use it as the qualifier to access its sqlite_master table:

tables = cursor.execute(f"SELECT name FROM {db_2_name}.sqlite_master WHERE type='table';").fetchall()

The above statement will be interpreted as:

SELECT name FROM db2.sqlite_master WHERE type='table';

How to list all the tables from the database in Sqlite flutter?

Just query sqlite_master table:

final tables = await database.rawQuery('SELECT * FROM sqlite_master ORDER BY name;');

Show Tables in SQLite Database in Python

The query to list tables in a Sqlite database:

SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;

So your snippet becomes:

con = sql.connect(r'/Users/linnk/Desktop/Results/GData.db')
mycur = con.cursor() 
mycur.execute("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;")
available_table=(mycur.fetchall())

See the Sqlite FAQ for more info.

sqlite get name of attached databases

Are you looking for this?

PRAGMA database_list;

PRAGMA database_list;

This pragma works like a query to return one row for each database
attached to the current database connection. The second column is the
"main" for the main database file, "temp" for the database file used
to store TEMP objects, or the name of the ATTACHed database for other
database files. The third column is the name of the database file
itself, or an empty string if the database is not associated with a
file.

How to display all the tables created in sqlite database on python3

you need to fetch the results from the query:

import sqlite3

conn = sqlite3.connect('boo2.db')
c = conn.cursor()

x=c.execute("SELECT * FROM sqlite_master where type='table'")

for y in x.fetchall():
    print(y)

List of tables, db schema, dump etc using the Python sqlite3 API

You can fetch the list of tables and schemata by querying the SQLITE_MASTER table:

sqlite> .tab
job         snmptarget  t1          t2          t3        
sqlite> select name from sqlite_master where type = 'table';
job
t1
t2
snmptarget
t3

sqlite> .schema job
CREATE TABLE job (
    id INTEGER PRIMARY KEY,
    data VARCHAR
);
sqlite> select sql from sqlite_master where type = 'table' and name = 'job';
CREATE TABLE job (
    id INTEGER PRIMARY KEY,
    data VARCHAR
)

---

Related Topics