InSQLSysObjects
- Last UpdatedMar 18, 2021
- 1 minute read
Contains one row for each object in the database for which changes can be tracked. This view provides backward compatibility support for the InSQLSysObjects table, which has been renamed to HistorianSysObjects.
|
Column |
Data Type |
Description |
|---|---|---|
|
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. |