|
|
|
This table categorizes the rows of the OBJECT_TYPE, PROPERTY_TYPE, ASSOCIATION_TYPE, and AGGREGATION_TYPE tables by DBMS. The following table describes the columns in the TARGET_DBMS table:
|
Column Name |
Data Type |
Description |
|---|---|---|
|
TYPE |
INTEGER |
The ID of an object type, property type, association type, or aggregation type. |
|
DBMS |
VARCHAR |
A constant indicating the DBMS in which the object is found. This value will correspond to the DBMS tag's ID defined in the ERwin Metamodel Reference document. A value of zero indicates any DBMS. |
|
DBMS_NAME |
VARCHAR |
The name of the DBMS. |
|
MIN_VERSION |
INTEGER |
The earliest version for which the type is defined. The format is the version number multiplied by 1000. For example, Version 7.2 would be 7200. A value of zero indicates all versions less than MAX_VERSION. |
|
MAX_VERSION |
INTEGER |
The latest version for which the type is defined. The format is the version number multiplied by 1000. For example, Version 7.2 would be 7200. A value of 999000 indicates all versions greater than MIN_VERSION. |
You can use a query similar to the following to see which CA ERwin DM DBMS targets define synonym objects.
Example: Query for returning synonym object definition by CA ERwin DM target database
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |