This SQL table contains one row for each property definition object that is stored in the Repository. The information contained in this table is used by Microsoft® Repository to create interface-specific SQL tables when an interface is added to Repository. The IntID, Z_BranchID_Z, and Z_VS_Z columns form the primary key for this table.
Column Name | Data Type | Description |
IntID | RTIntID | The internal identifier for the property definition object. |
Z_BranchID_Z | RTBrID | The value of this column is always zero. |
Z_VS_Z | RTVerID | The value of this column is always zero. |
Z_VE_Z | RTVerID | The value of this column is always VERINFINITY. |
SQLColName | RTSQLName | The name of the column in the SQL table for this property. This field can be null. |
APIType | RTSQLType | The C language data type for the property. This is the type of the property when it is passed through a Repository programming interface. |
SQLType | RTSQLType | The SQL data type for the property. |
SQLSize | RTSize | The length in bytes of the property in terms of its SQL data type. |
SQLScale | RTScale | The scale for a numeric property; the number of digits after the decimal point. This field can be null. |
Flags | RTFlags | Flags that determine property behavior. See the PropertyDefFlags Enumeration for a list of values and their specific purposes. |
Remarks
Remember that you can make only one version of each Property Type Definition. Nevertheless, this table includes the columns Z_BranchID_Z, Z_VS_Z, and Z_VE_Z because there are implementation advantages to including these columns. Similarly, the primary key includes the columns Z_BranchID_Z and Z_VS_Z for implementation reasons only.