[Info-vax] SQLite port for OpenVMS (Re: Is there currently a functioning link for hobbyist licenses?)

[Craig A. Berry]

On 3/14/15 4:16 PM, seasoned_geek wrote:

> Take something simply like "displaying all tables in the database".
> OnRDB and a few other database engines it is SHOW TABLES. On Oracle you
> have to SELECT some_column FROM USER_something_or_other; then SELECT
>some_column FROM SYSTEM_something_or_other; Under SQLite3 and a few
> other command shells it is .tables but under PostGreSQL it is \d

I think pretty much everybody except Oracle supports the ANSI standard
INFORMATION_SCHEMA views:

http://en.wikipedia.org/wiki/Information_schema