Describe DB Objects (Tables, etc)

[smartini]

Hi to all,
is it possible in H2 to show the structure (maybe in SQL) of a given
object, but without seeing or exporting the structure of all the DB
(script nodata) ?

The best could be to add additional (optional) arguments like
object_type (table, view, domain, etc) and then the object name (with
optional wildchars, but also on a single object could be useful). Or a
dedicated command, like SHOW ... as over.

For example, Oracle has a SQL command DESC / DESCRIBE object_type
object_name , like: describe table samples
But Oracle doesn't return the SQL DDL of the given objects, it returns
only a summary text with most common features.

What do you think ?

Thanks,
Sandro

[Thomas Mueller]

Hi,

> is it possible in H2 to show the structure (maybe in SQL) of a given
> object, but without seeing or exporting the structure of all the DB
> (script nodata) ?

The 'standard' was is to use the information_schema tables.

> Or a dedicated command, like SHOW ... as over.

Actually this is supported, but not documented so far. I will add the
following documentation:

SHOW { SCHEMAS | TABLES [FROM schemaName] |
COLUMNS FROM tableName [FROM schemaName] }

Lists the schemas, tables, or the columns of a table.

Examples:
SHOW SCHEMAS;
SHOW TABLES;
SHOW COLUMN FROM TEST;

Regards,
Thomas

[smartini]

Hi Thomas,
thanks for your help, I'll try the commands ...

Best regards,
Sandro