HELP

HELP — displays all the SQL statements available in NuoDB along with a detailed description.

This features is supported only in NuoDB SQL.

Syntax

HELP [ statement ]

Description

The HELP command is used to display all the SQL statements available in NuoDB in alphabetical order along with a detailed description of the specific SQL statements. For more information, see SQL Statements. The HELP command is only available in nuosql.

The HELP command is case insensitive.

Parameters

statement: This will display a more detailed description of the SQL statement. The statement must be a valid SQL statement that NuoDB supports and must be entered exactly as it appears in the output list displayed from the HELP command issued without arguments. This parameter is case insensitive.

Examples

Example 1: Display a list of all supported SQL statements

help

   ALTER PROCEDURE  ALTER PROCEDURE changes a stored procedure.
   ALTER SEQUENCE   ALTER SEQUENCE changes the starting value of an existing sequence.
   ALTER TABLE      Change definition of a table
...

Example 2: Display a detailed description of the specified SQL statement

HELP commit

NAME
      COMMIT
SYNOPSIS
      COMMIT [ WORK ]
DESCRIPTION
      COMMIT commits the current transaction. All changes made by the transaction
      become visible to others and are guaranteed to be durable if an unexpected
      interruption in service occurs. Use ROLLBACK to stop and undo a transaction.
      You can rollback to a savepoint, but you cannot commit a savepoint. A
      COMMIT implicitly releases all named savepoints. Type HELP SAVEPOINT for
      more information.