TYPEPROPERTY (T-SQL)

Returns information about a data type.

Syntax

TYPEPROPERTY( type, property )

Arguments

type

Is the name of the data type.

property

Is the type of information to be returned for the data type, and can be one of these values.

 

Property	Description	Value returned
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 Types

int

Example

This example returns the precision or number of digits for the integer data type.

SELECT TYPEPROPERTY( 'tinyint', 'PRECISION')

See Also