Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. How to query tables' name in a empty database in sqlite.
Forum Updated to NodeBB v4.3 + New Features

How to query tables' name in a empty database in sqlite.

Scheduled Pinned Locked Moved General and Desktop
2 Posts 2 Posters 916 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    adam_zhang
    wrote on last edited by
    #1

    I met problem, I want to show tables' name after I open a sqlite database, the faq in sqlite said that every database file has a table which's name sqlite_master. but the new database file is zero length file, I'm sure it has no sqlite_master. I just want to ask, in this situation, what I can do.

    1 Reply Last reply
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #2

      Hi,

      If the file size is zero, it probably means it's empty so there's nothing to query about.

      To ensure you have something in it (or not) you can use the sqlite3 command line application to edit the database

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved