Posted by sqliteonline 1 day ago
SELECT * FROM sqlite_schema WHERE type='table' ORDER BY name;
The website does seem to correctly return the names/schemas of whatever tables you've created if you run the command above, but the editor (incorrectly) adds red squigglies around the command, since I guess it doesn't realize this is allowed.