sqlite - Sqlite Wiki Faq

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 8,21 ****
  
  Or how do I find out what tables a SQLite database has?
  
! A) It's not as simple as "show tables", but it does work:
  
!   SELECT name FROM sqlite_master WHERE type = "table"
  
! I guess you could create a view to simplify frequent querying.
  
! Alternatively, if you are using the SQLite command line program, the following works fine:
!     .tables
  
  A) {link:http://www.sqlite.org/pragma.html#schema Pragmas used to query the schema of the current database.}
  
--- 8,24 ----
  
  Or how do I find out what tables a SQLite database has?
  
! A) If you are using the SQLite command line program, try this:
  
!   .tables
  
! You can also use a pattern that matches tables using a LIKE pattern:
  
!   .tables ?PATTERN?
! 
! If using another utility to access the database (or programmatically), this should work:
! 
!   SELECT name FROM sqlite_master WHERE type = "table"
  
  A) {link:http://www.sqlite.org/pragma.html#schema Pragmas used to query the schema of the current database.}