Welp SQL project question

Is there a way to get the data schema for all the tables quickly??

I’ve been using this code below:
SELECT *
FROM tablename

I do this do each table and would like to know a quicker way.

In SQLite:

.schema <tablename here no brackets>

or, if you have multiple tables that have the same suffix–users, learners, orders for example:

.schema '%ers'

I assume this will work in the LE. I haven’t tried it…

1 Like