Welp SQL project question

board2501067444 · December 5, 2022, 7:42pm

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.

lisalisaj · December 5, 2022, 9:14pm

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…