How to display all of the tables in all databases with one query

Question

.

Answer 1

It depends on which SQL engine you are using.
There are 2 searches I found.

Search terms: SQL get schema
https://stackoverflow.com/questions/1317398/get-sql-server-schema-via-a-sql-query

Search terms: sqlite show tables schema
https://www.beekeeperstudio.io/blog/sqlite-show-tables

Try to use the search engine, it is your friend.