Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

HistorianSysObjects

  • Last UpdatedMar 10, 2025
  • 1 minute read

Contains one row for each object in the database for which changes can be tracked.

Column

Data Type

Description

(PK) id

int NOT NULL

The unique identifier for the object.

Type

char(2) NULL

The type of object. C = CHECK constraint; D = Default or DEFAULT constraint; F = FOREIGN KEY constraint; K = PRIMARY KEY or UNIQUE constraint; L = Log; P = Stored procedure; R = Rule; RF = Stored procedure for replication; S = System table; TR = Trigger; U = User table; V = View; X = Extended stored procedure. Currently, only changes for the user tables (object type U) are tracked.

Name

varchar(50) NULL

The name of the modified object.

Related Links
TitleResults for “How to create a CRG?”Also Available in