---
title: "DataTypes (SQL Server)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Metadata.DataTypes
original: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Metadata.DataTypes
updated: 2026-11-18T23:25:40Z
license: https://documentation.invantive.eu/en/
---

# DataTypes: SQL Server

`read only`

- Catalog: `Database`
- Schema: `Metadata`

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 | [ ] |  |  |

