Page History
...
Stores snapshots of the instances’ properties. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQID_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQID_CONFIG_OPTION_ID | ID of the instance property, as appearing in sp_configure . |
SQID_CONFIG_OPTION_NAME | Name of the instance property, as appearing in sp_configure . |
SQID_CONFIG_OPTION_VALUE | Value of the instance property. |
PW_SQCO_SCHEMA_CHANGES_OBJECTS
Stores snapshots of the instance objects’ properties. The object can be a table or a stored object such as a view, trigger, user-defined function, or stored procedure. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCO_DATABASE_ID | Internal ID of the database. |
SQCO_OBJECT_ID | ID of the object that was changed. |
SQCO_NAME | Name of the object that was changed. |
SQCO_OWNER | Owner of the object that was changed. |
SQCO_TYPE | Type of the object that was changed. See sysobjects documentation for a list of all available types. |
SQCO_CREATE_DATE |
SQCO_FILE_GROUP
SQCO_NUM_OF_COLUMN
SQCO_EXEC_IS_ANSI_NULL_ON
SQCO_TABLE_HAS_INDEX
SQCO_TABLE_HAS_CLUSTERED_INDEX
SQCO_DELETE_TRIGGER_COUNT
SQCO_INSERT_TRIGGER_COUNT
SQCO_UPDATE_TRIGGER_COUNT
SQCO_NUM_OF_PARTITIONS
...
Creation date of the object. | |
SQCO_FILE_GROUP | File group in which the object resides. Relevant only for tables. |
SQCO_NUM_OF_COLUMN | Number of columns in the object. |
SQCO_EXEC_IS_ANSI_NULL_ |
...
ON | Value of the object’s Ansi Null property. Relevant only for stored objects. |
SQCO_TABLE_HAS_INDEX | TRUE if the table has an index, |
...
FALSE if the table does not have an indexes. |
SQCO_TABLE_HAS_CLUSTERED |
...
_INDEX | TRUE if the table has a clustered index, |
...
FALSE if the table does not have a clustered index. |
SQCO_DELETE_TRIGGER_ |
...
COUNT | Number of delete triggers on the table. |
SQCO_INSERT_TRIGGER_ |
...
COUNT | Number of insert triggers on the table. |
SQCO_UPDATE_TRIGGER_ |
...
COUNT | Number of update triggers on the table. |
SQCO_NUM_OF_PARTITIONS | Number of partitions per object. |