List all tables in a DB using SQLite

Question

I can't seem to find documentation (that I understand) on how to list all tables in a database. I've tried the following:

SELECT * FROM .table;
SELECT * FROM .tab;
SELECT * FROM .db;
SELECT * FROM world.db;

None of them worked. I'm just learning SQL, so forgive my ignorance. :0)

fooser · Accepted Answer · 2014-03-14 15:37:27Z

24

Try this:

SELECT * FROM sqlite_master WHERE type='table'

answered Mar 14, 2014 at 15:37

fooser

9026 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr.Syrax Over a year ago

Thanks! I was just about to edit my post to add SELECT * FROM world.sqlite_master WHERE type='table'; to the queries I tried. looks like I had too much info in mine.

Jespertheend May 14 at 13:36

Note that sqlite_master was renamed to sqlite_schema, though the old name remains working for backwards compatibility.

Zombo · Accepted Answer · 2020-12-17 22:30:43Z

10

If you are in interactive mode, you can use this:

.tables

Another method with extra information:

.schema

https://sqlite.org/cli.html#querying_the_database_schema

answered Dec 17, 2020 at 22:30

Zombo

1

Collectives™ on Stack Overflow

List all tables in a DB using SQLite

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related