Page History
...
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 | 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. |
PW_SQCK_SCHEMA_CHANGES_INDXKEY
Stores snapshots of the index keys. 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
SQCK_PWII_INSTANCE_ID ID of the SQL Server instance.
SQCK_DATABASE_ID Internal ID of the database.
SQCK_OBJECT_ID ID of the object the index is defined on.
SQCK_INDEX_ID ID of the index.
SQCK_COLUMN_ID ID of the column.
SQCK_COLUMN_NAME Name of the column key.
SQCK_INDEX_NAME Name of the index.
SQCK_OBJECT_NAME Name of the table.
SQCK_OBJECT_OWNER Owner of the table.
SQCK_POSITION Position of the key in the index.
SQCK_ORDER_BY Sorting of the key in the index.