Every database vendor like Oracle, MSSQL, PostgreSQL, MySQL, and H2,… speaks the same principal language SQL with a lot of hues specific to each implementation forming a dialect. Like all of them, SQL Cloud has its own dialect.
...
to display the column and their metadata of a given table:
...
Table, column and function names are case sensitive
In example:
| Code Block | ||
|---|---|---|
| ||
select * from PROJECT |
will work.
Whereas
| Code Block | ||
|---|---|---|
| ||
select * from project |
will not.
...
No schema names
Many database vendors group their tables into schemas (i.e.: PUBLIC). SQL Cloud does not support them.
...