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. |