This?
http://onewebsql.com/blog/list-all-tables
SQL Server or SqLite aren't included in these examples, but there's usually a way to do it whatever the database is. There's usually also a way to get database relationships.
As mentioned, a GUI is usually preferred as it may also be able to show them well visually.
(*) These examples haven't been tested and are only to show it's possible.