Category: Accounting
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the Database Name of the object for which access count and/or UDI counts are recorded. |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the table whose column was accessed by a query. |
FieldName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns Field Name of a table if usage type is a DML type; StatsId if the usage is for statistics (the optimizer usage of statistics). |
UsageType | CHAR(3) LATIN UPPERCASE NOT NULL | X(3) | Returns the usage type of the object. It can be either DML or STA. |
AccessCount | BIGINT | --,---,---,---,---,---,--9 | Returns the number of accesses since the last reset by the user. |