15.00 - HELP DATABASE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

HELP DATABASE

HELP DATABASE Attributes

The following table lists the attributes reported as the result of a HELP DATABASE request. For each object in the database (not just tables, views, and macros), the system returns the attributes listed in the table below.

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

CHARACTER(30)

No

The name of an of an object in the database specified in the HELP request.

Kind

CHARACTER

No

Identifies the object type 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, if a comment was created. for the database.

Protection

CHARACTER

No

Indicates whether the database uses fallback protection.

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

    CHARACTER(30)

    No

    The name of the creator for the database.

    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

    No

    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 derived from and supersede the corresponding older Table/View/Macro Name and Creator Name attributes, while providing additional functionality.

    The system returns these attributes for each object in the specified database.

    The older attributes are retained for compatibility with legacy applications.

    For details on the new attributes, 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