Precise for SQL Server tables

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.

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.

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.