RTblPropDefs SQL Table

See Also

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.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.