There is no
information_schema in SQLite as pointed out by @mustaccio.
However, you can get the information you require by using this SQL:
type ='table' AND
name NOT LIKE 'sqlite_%';
See the link here. Tables which begin with
sqlite_ are SQLite's system tables and are explained here. Remember that SQLite databases are single files with all of the data and metadata stored in that one file!
Anyway, there's another problem with your SQL - a
LIMIT clause makes no sense without being preceded by an
ORDER BY clause. Quite why one would want the first 20 of an alphabetical list of tables is not clear to me? Normally,
LIMITs apply to numerical data - I'm not saying it's an absolute requirement, just puzzling, that's all!
If this is, as your comment suggests, an exploratory look at the data, then use the
.output command from the
sqlite3 client programme and get a list of all the tables (see here). Then you can use the
more command to browse through this list of tables?
There are a few articles about how to ask questions here on my profile - you might want to take a look?