Syntax of TYPEPROPERTY Function :
TYPEPROPERTY ( type, property )
type is a name of the data type. It is of type integer.
property is a property name. It can be of below values.
Property | Description | Returned Value |
Precision | Precision for the data type. | The number of digits or characters. NULL = Data type not found. |
Scale | Scale for the data type. | The number of decimal places for the data type. NULL = Data type is not numeric or not found. |
AllowsNull | Data type allows null values. | 1 = True
0 = False
NULL = Data type not found. |
UsesAnsiTrim | ANSI padding setting was ON when the data type was
created. | 1 = True
0 = False
NULL = Data type not found, or it is not a binary or string data type. |
Return type of TYPEPROPERTY function is an integer.
Examples of TYPEPROPERTY Function :
Example 1 : Use of TYPEPROPERTY function in select clause
SELECT TYPEPROPERTY( 'DateTime', 'AllowsNull' )
Above example returns 1 means DateTime datatype allows null value.