Is there an alternative (like a command to list all tables and which works on all DBMS)?
I mean using a specific sqlite/oracle/tsql/... command wouldn't be any better.
No, there isn't. But I don't see the need to start with these commands anyway. Or if the OP really feels like that's a necessary starting point, it would be great to have an option in the future to select what DBMS you're using. I wasn't intending to bash the work, but sticking to a single DBMS really limits the utility of what seems like it could be very general resource.
I like the idea of being able to select which dialect one wants to learn and maybe a table listing the most prominent differences (like LIMIT vs. TOP) at the end, would be nice too.
In theory `information_schema` is supposed to be universal, so you could do `select table_name from information_schema.tables`. However, getting useful information out of `information_schema` tends to require fairly complex queries and still has quirks and differences between databases.
i.e. "You may limit number of records using LIMIT keyword"
Postgres seems to use that as well.
Limit is the standard isn't it? Only Sybase/MSSQL Server use top x afaicr.