SHOW

SHOW — display information about select database objects and states

Syntax

SHOW 
SHOW { TABLES | DOMAINS | SEQUENCES | PROCEDURES | FUNCTIONS }
    [ { FROM | IN } [SCHEMA] schema_name ] 
    [ LIKE 'string_literal' ]
SHOW { TABLE | DOMAIN | SEQUENCE | PROCEDURE | FUNCTION } 
    [schema_name.]object_name
SHOW SCHEMA [ schema_name ]
SHOW SCHEMAS [ LIKE 'string_literal' ]
SHOW DATABASE
SHOW object_name
SHOW AUTOCOMMIT

Description

SHOW displays information about schemas, tables, domains, sequences, procedures, and user defined functions.
SHOW will also return partial matches in the above categories.
You can also use SHOW to determine the status of the setting for AUTOCOMMIT and other useful settings in nuosql.
By default SHOW uses the current schema, if none is specified. SHOW commands do not require a semi-colon to execute.
If NuoDB cannot find a table, domain, sequence or procedure with the exact name that is specified, it searches for database objects beginning with the characters in the specified object_name, in the current or specified schema_name.
SHOW DATABASE will show version number information about your database and all the nodes running in your database. SHOW with no arguments will show information about your database and your client session including any system defined properties.

Parameters

Examples