TYPEPROPERTY#
Returns information about a data type.
Syntax#
Arguments#
type
Is the name of the data type.
‘property’
Is the type of information to be returned for the data type. property can be one of the following values:
Property |
Description |
Value returned |
---|---|---|
AllowsNull |
Data type allows for null values. |
1 = True 0 = False NULL = Data type not found. |
OwnerId |
Owner of the type. Note: The schema owner is not necessarily the type owner. |
Nonnull = The database user ID of the type owner. Default is: 4 NULL = Unsupported type, or type ID is not valid. |
Precision |
Precision for the data type. |
The number of digits or characters. =1 = xml or large value data type 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. |
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 types#
int
Example#
SELECT TYPEPROPERTY(SCHEMA_NAME(schema_id) + '.' + name, 'OwnerId') AS owner_id
, name
, system_type_id
, user_type_id, schema_id
FROM sys.types
;