IsValidKeyDatatype Method
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The IsValidKeyDatatypemethod returns TRUE when the data type specified can participate in a PRIMARY KEY or FOREIGN KEY constraint.
Syntaxe
object.IsValidKeyDatatype(Type , [ ReferencingType ] )
Parts
object
Expression that evaluates to an object in the Applies To list.Type
String that identifies a single base or user-defined data type by name.ReferencingType
Optional. A string that identifies a second base or user-defined data type by name.
Prototype (C/C++)
HRESULT IsValidKeyDatatype(
SQLDMO_LPCSTR szKeyColType,
LPBOOL pRetVal,
SQLDMO_LPCSTR szReferencingColType = NULL);
Returns
TRUE or FALSE as described in Remarks.
Notes
When only the Type argument is used, the IsValidKeyDatatype method returns TRUE when a column defined using the data type can participate in a PRIMARY KEY constraint.
When a second data type is specified in the ReferencingType argument, the IsValidKeyDatatype method returns TRUE when the types are compatible. A TRUE return value indicates that a column defined using one data type could reference a column defined using the other data type in a FOREIGN KEY constraint.