invantive documentation
Invantive Support ForumsLog In / Sign Up

DataTypes: SQL Server Data Types

read only

  • Catalog: Database
  • Schema: Invantive
  • Label: Data Types

Can only retrieve data.

Table Columns

The columns of the table DataTypes are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
COLUMN_SIZE int64 Column Size
CREATE_FORMAT varchar2(240) Create Format
CREATE_PARAMETERS varchar2(240) Create Parameters
DATA_TYPE varchar2(240) Data Type
IS_AUTOINCREMENTABLE char Is Auto-incrementable
IS_BEST_MATCH char Is Best Match
IS_CASE_SENSITIVE char Is Case-sensitive
IS_CONCURRENCY_TYPE char Is Concurrency Type
IS_FIXED_LENGTH char Is Fixed Length
IS_FIXED_PRECISION_SCALE char Is Fixed Precision Scale
IS_LITERAL_SUPPORTED char Is Literal Supported
IS_LONG char Is Long
IS_NULLABLE char Is Nullable
IS_SEARCHABLE char Is Searchable
IS_SEARCHABLE_WITH_LIKE char Is Searchable with Like
IS_UNSIGNED char Is Unsigned
LITERAL_PREFIX varchar2(240) Literal Prefix
LITERAL_SUFFIX varchar2(240) Literal Suffix
MAXIMUM_SCALE int16 Maximum Scale
MINIMUM_SCALE int16 Minimum Scale
NATIVE_DATA_TYPE varchar2(240) Native Data Type
PROVIDER_DB_TYPE int32 Provider Database Type
SCHEMA_NAME varchar2(240) Schema
TYPE_NAME varchar2(240) Type Name