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

# AllColumns: SQL Server

`read only`

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

Can only retrieve data.

## Table Columns

The columns of the table `AllColumns` 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 |
|---|---|---|:---:|---|---|
| `CHARACTER_MAXIMUM_LENGTH` | `int32` | CHARACTER_MAXIMUM_LENGTH | [ ] |  |  |
| `CHARACTER_OCTET_LENGTH` | `int32` | CHARACTER_OCTET_LENGTH | [ ] |  |  |
| `CHARACTER_SET_CATALOG` | `varchar2` | CHARACTER_SET_CATALOG | [ ] |  |  |
| `CHARACTER_SET_NAME` | `varchar2` | CHARACTER_SET_NAME | [ ] |  |  |
| `CHARACTER_SET_SCHEMA` | `varchar2` | CHARACTER_SET_SCHEMA | [ ] |  |  |
| `COLLATION_CATALOG` | `varchar2` | COLLATION_CATALOG | [ ] |  |  |
| `COLUMN_DEFAULT` | `varchar2` | COLUMN_DEFAULT | [ ] |  |  |
| `COLUMN_NAME` | `varchar2` | COLUMN_NAME | [ ] |  |  |
| `DATA_TYPE` | `varchar2` | DATA_TYPE | [ ] |  |  |
| `DATETIME_PRECISION` | `int16` | DATETIME_PRECISION | [ ] |  |  |
| `IS_COLUMN_SET` | `char` | IS_COLUMN_SET | [ ] |  |  |
| `IS_FILESTREAM` | `char` | IS_FILESTREAM | [ ] |  |  |
| `IS_NULLABLE` | `varchar2` | IS_NULLABLE | [ ] |  |  |
| `IS_SPARSE` | `char` | IS_SPARSE | [ ] |  |  |
| `NUMERIC_PRECISION` | `byte` | NUMERIC_PRECISION | [ ] |  |  |
| `NUMERIC_PRECISION_RADIX` | `int16` | NUMERIC_PRECISION_RADIX | [ ] |  |  |
| `NUMERIC_SCALE` | `int32` | NUMERIC_SCALE | [ ] |  |  |
| `ORDINAL_POSITION` | `int32` | ORDINAL_POSITION | [ ] |  |  |
| `TABLE_CATALOG` | `varchar2` | TABLE_CATALOG | [ ] |  |  |
| `TABLE_NAME` | `varchar2` | TABLE_NAME | [ ] |  |  |
| `TABLE_SCHEMA` | `varchar2` | TABLE_SCHEMA | [ ] |  |  |

