15.10 - DatabasesV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Database

DBC

 

View Column

Data Type

Format

Source Table.Column

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.CreatorName

OwnerName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.OwnerName

AccountName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.AccountName

ProtectionType

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

Dbase.ProtectionType

JournalFlag

CHAR(2) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(2)

Dbase.JournalFlag

PermSpace

FLOAT

NOT NULL

ZZZ,ZZZ,ZZZ,ZZZ,ZZ9

Dbase.PermSpace

SpoolSpace

FLOAT

NOT NULL

ZZZ,ZZZ,ZZZ,ZZZ,ZZ9

Dbase.SpoolSpace

TempSpace

FLOAT

NOT NULL

ZZZ,ZZZ,ZZZ,ZZZ,ZZ9

Dbase.TempSpace

CommentString

VARCHAR(255)

UNICODE

NOT CASESPECIFIC

X(255)

Dbase.CommentString

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

Dbase.CreateTimeStamp

LastAlterName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

LastAlterTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

Dbase.LastAlterTimeStamp

DBKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

Dbase.RowType

AccessCount

BIGINT

--,---,---,---,---,---,--9

ObjectUsage.UserAccessCnt

LastAccessTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ObjectUsage.LastAccessTime
Stamp

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • You can use this view to query the characteristics of the databases you own and which you have privileges on.

    For information about the possible values for the JournalFlag column, see Appendix A: “View Column Values.”

    AccountName

    The AccountName column is the unexpanded default account name for the user or database. A database can only have one account. A user may have a default account plus other accounts. If there is a profile for the user, and it specifies a default account, that account superseded this account name.

    JournalFlag

    The indicators in the JournalFlag column depend on:

  • The FALLBACK and JOURNAL settings for the database, which serve as the default for all tables created in that database
  • Any FALLBACK and JOURNAL settings defined in the CREATE TABLE and ALTER TABLE statements
  • The settings defined for an individual table override the database defaults. For all the account names associated with a database or user, use the AccountInfo[X] system view.

    The statement shown in the following selects information about the Personnel database:

    ==> SELECT AccountName,ProtectionType,PermSpace,SpoolSpace
           FROM DBC.DatabasesV WHERE DatabaseName = ’Personnel’;

    Result:

    AccountName       ­ProtectionType  ­PermSpace   ­SpoolSpace
    ---------------   --------------  ---------   -------------
    Teradata_Sample   F               100,000     1,339,884,032