17.00 - DatabasesV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Database

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a database or one of the special system keywords: ALL / DEFAULT / PUBLIC.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the Teradata user who issued the CREATE DATABASE statement.
OwnerName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Database owner name.
AccountName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Expanded account in effect when a request was submitted. SYSTEMACCOUNTNO tracks console utility activity such as table rebuild, Diskcopy, or Scandisk.
ProtectionType CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns F (Fallback) or N (None) to indicate whether the tables in the database are protected by the Fallback option.
JournalFlag CHAR(2) LATIN UPPERCASE NOT NULL X(2) Journaling in effect for the table, or the journal default for tables. Settings: first character BEFORE, second character AFTER.
PermSpace BIGINT NOT NULL --,---,---,---,---,---,--9 Returns an integer indicating the total space allocated to the database on all AMPs.
SpoolSpace BIGINT NOT NULL --,---,---,---,---,---,--9 Returns an integer indicating the maximum spool space allowed for the database. SpoolSpace is 0 if DatabaseName is PUBLIC.
TempSpace BIGINT NOT NULL --,---,---,---,---,---,--9 Returns the maximum temporary space allocated for a database, profile, or user in bytes.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns user-supplied text or commentary on the column, database, table, view, macro, user-defined function, user-defined types, user-defined methods, stored procedure, role, profile, or user.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time that the object in the row was created.
LastAlterName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the user who last updated the dictionary row.
LastAlterTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time the dictionary row was last updated.
DBKind CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns information that indicates whether the row information represents a database (D) or a user (U).
AccessCount BIGINT --,---,---,---,---,---,--9 Returns the access count for the corresponding database object.
LastAccessTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time that the corresponding object was last accessed.
DefaultMapName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the default mapname for the database or user. NULL indicates the database or user does not have a default map.
MapOverride VARCHAR(1) LATIN NOT CASESPECIFIC X(1) MapOverride indicates no override or override on error for the default map. "N" indicates no override. "E" indicates OVERRIDE ON ERROR.
IncrementalRestoreEnabled INTEGER --,---,---,--9 Indicates if Incremental Restore has been enabled for the database.