15.00 - HELP USER - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

HELP USER

HELP User Attributes

The following table lists the attributes reported as the result of a HELP USER request.

Note: HELP does not differentiate between user and database objects, so HELP USER and HELP DATABASE commands that specify the same object name return the same information.

 

Attribute

Data Type

Nullable

Description

Table/View/Macro name

VARCHAR(30)

No

The name of an object created in the user space.

Kind

CHARACTER

No

Returns the object type code for the object identified by Table/View/Macro name.

See “TVM Kind Codes” on page 903.

Comment

VARCHAR(255)

Yes

The contents of the optional comment field for the user, if a comment was created.

Protection

CHARACTER

No

Indicates whether the user specifies default use of fallback protection.

  • F is Fallback.
  • N is None.
  • Creator Name

    VARCHAR(30)

    No

    The name of the user that created the user specified in this HELP USER request.

    Commit Option

    CHARACTER

    Yes

    Indicates whether rows are preserved upon COMMIT of the transaction.

  • D represents Delete rows on COMMIT.
  • P represents Preserve rows on COMMIT.
  • Note: This attribute applies to temporary tables only.

    Transaction Log

    CHARACTER

    Yes

    Indicates whether a transaction log is kept.

  • N means no log is kept.
  • Y means transactions are logged.
  • Note: This attribute applies to temporary tables only.

    Dictionary Name

    VARCHAR(128)

    No

    The attributes shown in this section are based upon and supersede the corresponding older attributes, Name and Creator Name, while providing additional functionality.

    The older attributes are retained for compatibility with existing applications.

    For details, see the topics beginning with “Working with Object Name and Title Data in HELP Reports” on page 896.

    SQL Name

    VARCHAR(644)

    UEscape

    VARCHAR(1)

    Yes

    Creator Dictionary Name

    VARCHAR(128)

    No

    Creator SQL Name

    VARCHAR(644)

    Creator UEscape

    VARCHAR(1)

    Yes