Read table names from SQLite in NodeJS

load_db.js

const sqlite3 = require('sqlite3').verbose();

// Open a database connection
const db = new sqlite3.Database('pkm.sqlite');

// Query to retrieve table names
const query = "SELECT name FROM sqlite_master WHERE type='table'";

// Execute the query
db.all(query, [], (err, rows) => {
  if (err) {
    console.error(err);
  } else {
    // Extract and display table names
    rows.forEach((row) => {
      console.log(row.name);
    });
  }

  // Close the database connection
  db.close();
});

Read table names from SQLite in NodeJS.md

Source: ChatGPT - A ShareGPT conversation