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_ |
int64 |
Column Size | |||
CREATE_ |
varchar2 |
Create Format | |||
CREATE_ |
varchar2 |
Create Parameters | |||
DATA_ |
varchar2 |
Data Type | |||
IS_ |
char |
Is Auto-incrementable | |||
IS_ |
char |
Is Best Match | |||
IS_ |
char |
Is Case-sensitive | |||
IS_ |
char |
Is Concurrency Type | |||
IS_ |
char |
Is Fixed Length | |||
IS_ |
char |
Is Fixed Precision Scale | |||
IS_ |
char |
Is Literal Supported | |||
IS_ |
char |
Is Long | |||
IS_ |
char |
Is Nullable | |||
IS_ |
char |
Is Searchable | |||
IS_ |
char |
Is Searchable with Like | |||
IS_ |
char |
Is Unsigned | |||
LITERAL_ |
varchar2 |
Literal Prefix | |||
LITERAL_ |
varchar2 |
Literal Suffix | |||
MAXIMUM_ |
int16 |
Maximum Scale | |||
MINIMUM_ |
int16 |
Minimum Scale | |||
NATIVE_ |
varchar2 |
Native Data Type | |||
PROVIDER_ |
int32 |
Provider Database Type | |||
SCHEMA_ |
varchar2 |
Schema | |||
TYPE_ |
varchar2 |
Type Name |