NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
H-3
Examples—HELP
In some cases, HELP contains additional “pointer entries” that direct you to
available topics. For example, if you enter HELP CREATE, SQLCI responds by
listing available topics that begin with the word “create”:
Enter: HELP create catalog
create constraint
create collation
create index
create system catalog
create table
create view
•
If the entire help text for a topic fits on the screen, SQLCI displays the text and
returns you to the standard SQLCI prompt. If the help text is too long for one screen,
SQLCI displays the first part of the text followed by a continuation prompt. SQLCI
displays information at the bottom of each screen of text that tells you what to press
to display more information or to return to the standard prompt.
Examples—HELP
•
The following command displays the available HELP topics:
HELP ALL;
•
The following commands display information about the CREATE TABLE
statement. The information displayed by the third command includes all the
information displayed by the first two commands:
HELP CREATE TABLE;
HELP CREATE TABLE, EXAMPLE;
HELP CREATE TABLE, DETAIL;
HELP TEXT Statement
HELP TEXT is a DDL statement that specifies help text for a column of a table or view.
column
is the name of a column with which to associate help text.
name
is the name of a table or view that includes the column.
HELP TEXT FOR COLUMN column ON { name }
IS text-line [, text-line ] ...