TYPEPROPERTY

Transact-SQL Reference

Transact-SQL Reference

TYPEPROPERTY

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. property 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

Examples

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

SELECT TYPEPROPERTY( 'tinyint', 'PRECISION')

See Also

COLUMNPROPERTY

Metadata Functions

OBJECTPROPERTY