PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column. |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE). |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_SQDL_INST_DB_DEFINITION_LOG
Tracks changes on instance/database definitions. It contains a list of all changes that occur in the instance/database definition.
| Column Name | Column Description |
|---|---|
SQDL_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDL_DATABASE_NAME | Name of the database in which the change occurred. |
SQDL_OLD_VALUE | Old value, before the change. |
SQDL_NEW_VALUE | New value, after the change. |
SQDL_CHANGE_TYPE | Type of the performed change (Created, Dropped, Updated). |
SQDL_DATA_CHANGED | Property that was changed. |
SQDL_SAMPLE_DATE | Date and time when the schema changes process ran. The actual change date is prior to the sample date and after the previous sample date. |
PW_SQCL_SCHEMA_CHANGES_LOG
Contains a list of all changes that occur in the object’s index, key, and column definitions.
| Column Name | Column Description |
|---|---|
SQCL_PWII | ID of the SQL Server instance. |
SQCL_DATABASE_ID | Internal ID of the database. |
SQCL_OBJECT_ID | ID of the object, column, or index that was changed, depending on the type of the object that was changed. |
SQCL_OBJECT_TYPE | Type of the object that was changed. |
SQCL_OBJECT_NAME | Name of the object that was changed. |
SQCL_OBJECT_OWNER | Owner of the object that was changed. |
SQCL_PARENT_OBJECT_ID | ID of the parent object that was changed. For example, if an index was changed, the parent object ID is the table ID. |
SQCL_PARENT_OBJECT_NAME | Name of the parent object name that was changed. For example: If an index was changed, the parent object name is the table name. |
SQCL_PARENT_OBJECT_OWNER | Owner of the parent object owner that was changed. For example: If an index was changed, the parent object owner is the table owner. |
SQCL_INDEX_ID | ID of the index that was changed. Relevant only for index key changes. |
SQCL_INDEX_NAME | Name of the index that was changed. Relevant only for index key changes. |
SQCL_OLD_VALUE | Old value (before the change). |
SQCL_NEW_VALUE | New value (after the change). |
SQCL_CHANGE_TYPE | Type of the performed change (Created, Dropped, Updated). |
SQCL_DATA_CHANGED | Name of the property that was changed. |
SQCL_SAMPLE_DATE | Date and time when the schema changes process run. |
PW_SQID_SCHEMA_CHANGES_INST
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 |
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_O N 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_COUN T Number of delete triggers on the table.
SQCO_INSERT_TRIGGER_COUN T Number of insert triggers on the table.
SQCO_UPDATE_TRIGGER_COUN T Number of update triggers on the table.
SQCO_NUM_OF_PARTITIONS Number of partitions per object.