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.