How to show all table names in luasql

Question

guys. I want to display all table names in luasql sqlite3. I tried serveral ways but none of them succeeded. Can anyone help me? thanks a lot!

score 2 · Answer 1 · answered Mar 31 '16 at 06:29

2

SELECT name FROM sqlite_master WHERE type = "table"

answered Mar 31 '16 at 06:29

Morten Bergfall

is there a way to get name of the file(sqlite3 file) – Ratatouille Oct 24 '18 at 14:24

1 Answers1