ColumnDataType Class

public final class ColumnDataType
extends ExpandableStringEnum<ColumnDataType>

The column data type.

Field Summary

Modifier and Type Field and Description
static final ColumnDataType BIGINT

bigint.

static final ColumnDataType BINARY

binary.

static final ColumnDataType BIT

bit.

static final ColumnDataType CHAR

char.

static final ColumnDataType DATE

date.

static final ColumnDataType DATETIME

datetime.

static final ColumnDataType DATETIME2

datetime2.

static final ColumnDataType DATETIMEOFFSET

datetimeoffset.

static final ColumnDataType DECIMAL

decimal.

static final ColumnDataType FLOAT

float.

static final ColumnDataType GEOGRAPHY

geography.

static final ColumnDataType GEOMETRY

geometry.

static final ColumnDataType HIERARCHYID

hierarchyid.

static final ColumnDataType IMAGE

image.

static final ColumnDataType INT

int.

static final ColumnDataType MONEY

money.

static final ColumnDataType NCHAR

nchar.

static final ColumnDataType NTEXT

ntext.

static final ColumnDataType NUMERIC

numeric.

static final ColumnDataType NVARCHAR

nvarchar.

static final ColumnDataType REAL

real.

static final ColumnDataType SMALLDATETIME

smalldatetime.

static final ColumnDataType SMALLINT

smallint.

static final ColumnDataType SMALLMONEY

smallmoney.

static final ColumnDataType SQL_VARIANT

sql_variant.

static final ColumnDataType SYSNAME

sysname.

static final ColumnDataType TEXT

text.

static final ColumnDataType TIME

time.

static final ColumnDataType TIMESTAMP

timestamp.

static final ColumnDataType TINYINT

tinyint.

static final ColumnDataType UNIQUEIDENTIFIER

uniqueidentifier.

static final ColumnDataType VARBINARY

varbinary.

static final ColumnDataType VARCHAR

varchar.

static final ColumnDataType XML

xml.

Constructor Summary

Constructor Description
ColumnDataType()

Deprecated

Use the fromString(String name) factory method.

Creates a new instance of ColumnDataType value.

Method Summary

Modifier and Type Method and Description
static ColumnDataType fromString(String name)

Creates or finds a ColumnDataType from its string representation.

static Collection<ColumnDataType> values()

Gets known ColumnDataType values.

Methods inherited from ExpandableStringEnum

Methods inherited from java.lang.Object

Field Details

BIGINT

public static final ColumnDataType BIGINT

bigint.

BINARY

public static final ColumnDataType BINARY

binary.

BIT

public static final ColumnDataType BIT

bit.

CHAR

public static final ColumnDataType CHAR

char.

DATE

public static final ColumnDataType DATE

date.

DATETIME

public static final ColumnDataType DATETIME

datetime.

DATETIME2

public static final ColumnDataType DATETIME2

datetime2.

DATETIMEOFFSET

public static final ColumnDataType DATETIMEOFFSET

datetimeoffset.

DECIMAL

public static final ColumnDataType DECIMAL

decimal.

FLOAT

public static final ColumnDataType FLOAT

float.

GEOGRAPHY

public static final ColumnDataType GEOGRAPHY

geography.

GEOMETRY

public static final ColumnDataType GEOMETRY

geometry.

HIERARCHYID

public static final ColumnDataType HIERARCHYID

hierarchyid.

IMAGE

public static final ColumnDataType IMAGE

image.

INT

public static final ColumnDataType INT

int.

MONEY

public static final ColumnDataType MONEY

money.

NCHAR

public static final ColumnDataType NCHAR

nchar.

NTEXT

public static final ColumnDataType NTEXT

ntext.

NUMERIC

public static final ColumnDataType NUMERIC

numeric.

NVARCHAR

public static final ColumnDataType NVARCHAR

nvarchar.

REAL

public static final ColumnDataType REAL

real.

SMALLDATETIME

public static final ColumnDataType SMALLDATETIME

smalldatetime.

SMALLINT

public static final ColumnDataType SMALLINT

smallint.

SMALLMONEY

public static final ColumnDataType SMALLMONEY

smallmoney.

SQL_VARIANT

public static final ColumnDataType SQL_VARIANT

sql_variant.

SYSNAME

public static final ColumnDataType SYSNAME

sysname.

TEXT

public static final ColumnDataType TEXT

text.

TIME

public static final ColumnDataType TIME

time.

TIMESTAMP

public static final ColumnDataType TIMESTAMP

timestamp.

TINYINT

public static final ColumnDataType TINYINT

tinyint.

UNIQUEIDENTIFIER

public static final ColumnDataType UNIQUEIDENTIFIER

uniqueidentifier.

VARBINARY

public static final ColumnDataType VARBINARY

varbinary.

VARCHAR

public static final ColumnDataType VARCHAR

varchar.

XML

public static final ColumnDataType XML

xml.

Constructor Details

ColumnDataType

@Deprecated
public ColumnDataType()

Deprecated

Use the fromString(String name) factory method.

Creates a new instance of ColumnDataType value.

Method Details

fromString

public static ColumnDataType fromString(String name)

Creates or finds a ColumnDataType from its string representation.

Parameters:

name - a name to look for.

Returns:

the corresponding ColumnDataType.

values

public static Collection<ColumnDataType> values()

Gets known ColumnDataType values.

Returns:

known ColumnDataType values.

Applies to