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

# Columnas: SQL Server

`read only`

- Catálogo: `Database`
- Esquema: `Metadata`

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `Columns`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | 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 | [ ] |  |  |
