Function: sqlite-mode-list-tables

sqlite-mode-list-tables is an interactive and byte-compiled function defined in sqlite-mode.el.gz.

Signature

(sqlite-mode-list-tables)

Documentation

Re-list the tables from the currently selected database.

Key Bindings

Source Code

;; Defined in /usr/src/emacs/lisp/sqlite-mode.el.gz
(defun sqlite-mode-list-tables ()
  "Re-list the tables from the currently selected database."
  (interactive nil sqlite-mode)
  (let ((inhibit-read-only t)
        (db sqlite--db)
        (entries nil))
    (erase-buffer)
    (dolist (table (sqlite-select db "select name from sqlite_master where type = 'table' and name not like 'sqlite_%' order by name"))
      (push (list (car table)
                  (caar (sqlite-select db (format "select count(*) from \"%s\""
                                                  (car table)))))
            entries))
    (sqlite-mode--tablify '("Table Name" "Number of Rows")
                          (nreverse entries)
                          'table)
    (goto-char (point-min))))