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. |