SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
H-1
H
HEADING Clause
HEADING is a clause in the ALTER TABLE, ALTER VIEW, CREATE TABLE, and
CREATE VIEW statements that specifies a default heading for a column.
HEADING string
specifies a default heading for a column, expressed as a string of single-byte or
multi-byte characters enclosed in single or double quotation marks. string can be
0 to 132 bytes long.
string cannot include the character string specifier normally allowed on a string
literal.
To indicate line breaks in a heading, use the new-line character. The default new-
line character is a slash (/). You can specify up to 50 lines in a single heading.
NO HEADING
specifies that no default heading should be printed for the column.
Consideration—HEADING
If you do not specify the HEADING clause, SQL uses the column name when printing
or displaying the column.
Example—HEADING
This ALTER TABLE statement specifies Customer as the default heading for column
CUSTOMER_NAME in table CUST. The new heading replaces any existing heading
for the column.
ALTER TABLE CUST COLUMN CUSTOMER_NAME HEADING "Customer"
HEADING string | NO HEADING