The following table provides getTypeInfo() results for supported data types.

TYPE_NAME = bigint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -5 (BIGINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = bigint
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = bigint identity

  • AUTO_INCREMENT = true
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -5 (BIGINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = bigint identity
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 0
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = binary

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = -2 (BINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = binary
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8000
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = bit

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -7 (BIT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = bit
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = char

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = 1 (CHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = char
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8000
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = date

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 91 (DATE)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = date
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 10
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = datetime

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = datetime
  • MAXIMUM_SCALE = 3
  
  • MINIMUM_SCALE = 3
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 23
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = datetime2

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = datetime2
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 27
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = datetimeoffset

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR) or
  • 93 (TIMESTAMP) 1
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = datetimeoffset
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 34
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = decimal

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision,scale
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = decimal
  • MAXIMUM_SCALE = 38
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = decimal() identity 2

  • AUTO_INCREMENT = true
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = decimal() identity
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 0
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = float

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 6 (FLOAT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = float
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 2
  • PRECISION = 53
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = image3

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = image
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 0
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = int

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = int
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = int identity

  • AUTO_INCREMENT = true
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = int identity
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 0
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = money

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = true
  • LITERAL_PREFIX = $
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = money
  • MAXIMUM_SCALE = 4
  
  • MINIMUM_SCALE = 4
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = nchar

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = length
  • DATA_TYPE = -15 (NCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = N'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = nchar
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 4000
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = ntext4

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -16 (LONGNVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = N'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = ntext
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1073741823
  • SEARCHABLE = 1
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = numeric

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision,scale
  • DATA_TYPE = 2 (NUMERIC)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = numeric
  • MAXIMUM_SCALE = 38 5
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = numeric() identity6

  • AUTO_INCREMENT = true
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = precision
  • DATA_TYPE = 2 (NUMERIC)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = numeric() identity
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 0
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = nvarchar

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = max length
  • DATA_TYPE = -9 (NVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = N'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = nvarchar
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 4000
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = nvarchar(max)

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -16 (LONGNVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = N'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = nvarchar(max)
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1073741823
  • SEARCHABLE = 1
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = real

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 7 (REAL)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = real
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 2
  • PRECISION = 24
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = smalldatetime

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = smalldatetime
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = smallint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 5 (SMALLINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = smallint
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 5
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = smallint identity7

  • AUTO_INCREMENT = true
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 5 (SMALLINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = smallint identity
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 0
  • NUM_PREC_RADIX = 10
  • PRECISION = 5
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = smallmoney

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = true
  • LITERAL_PREFIX = $
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = smallmoney
  • MAXIMUM_SCALE = 4
  
  • MINIMUM_SCALE = 4
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false

TYPE_NAME = sql_variant8

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = sql_variant
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 8000
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = sysname

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = N'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = sysname
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 0
  • NUM_PREC_RADIX = NULL
  • PRECISION = 128
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = text9

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = text
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 1
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = time

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = time
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 16
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = timestamp

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -2 (BINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = timestamp
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 0
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = tinyint

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -6 (TINYINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = tinyint
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 3
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = tinyint identity10

  • AUTO_INCREMENT = true
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -6 (TINYINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = tinyint identity
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 0
  • NUM_PREC_RADIX = 10
  • PRECISION = 3
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = true

TYPE_NAME = uniqueidentifier

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 1(CHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = uniqueidentifier
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 36
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varbinary

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = max length
  • DATA_TYPE = -3 (VARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = varbinary
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8000
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varbinary(max)

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -4 (LONGVARBINARY)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = 0x
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = varbinary(max)
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 0
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varchar

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = max length
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = varchar
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 8000
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = varchar(max)

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = varchar(max)
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 1
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = xml11

  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = true
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 2009 (SQLXML)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = N'
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = xml
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 1073741823
  • SEARCHABLE = 0
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL
1 When FetchTSWTZasTimestamp=false, the data type that is returned by DATA_TYPE is VARCHAR; when FetchTSWTZasTimestamp=true, the data type that is returned is TIMESTAMP.
2 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
3 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
4 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
5 This value can be configured with a server option in SQL Server and Azure.
6 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
7 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
8 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
9 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
10 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.
11 Not supported for Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System.