sp_datatype_info

Returns information about a particular ODBC datatype or about all ODBC datatypes.

Syntax

sp_datatype_info [data_type]

Parameters

Usage

The results set for sp_datatype_info is:

Column

Datatype

Description

type_name

varchar(30)

A DBMS-dependent datatype name (the same as the type_name column in the sp_columns results set).

data_type

smallint

A code for the ODBC type to which all columns of this type are mapped.

precision

int

The maximum precision for the datatype on the data source. Zero is returned for datatypes where precision is not applicable.

literal_prefix

varchar(32)

Character(s) used to prefix a literal. For example, a single quotation mark (') for character types and 0x for binary.

literal_suffix

varchar(32)

Character(s) used to terminate a literal. For example, a single quotation mark (') for character types and nothing for binary.

create_params

varchar(32)

A description of the creation parameters for this datatype.

nullable

smallint

The value 1 means this datatype can be created allowing null values; 0 means it cannot.

case_sensitive

smallint

The value 1 means all columns of this type are case sensitive (for collations); 0 means they are not.

searchable

smallint

The value 1 means columns of this type can be used in a where clause.

unsigned_attribute

smallint

The value 1 means the datatype is unsigned; 0 means the datatype is signed.

money

smallint

The value 1 means it is a money datatype; 0 means it is not.

auto_increment

smallint

The value 1 means the datatype is automatically incremented; 0 means it is not.

local_type_name

varchar(128)

Localized version of the data source dependent name of the datatype.

Permissions

Any user can execute sp_datatype_info.