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

# StructuredTypeMembers : SQL Server

`read only`

- Catalogue : `Database`
- Schéma : `Metadata`

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `StructuredTypeMembers` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | 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 | [ ] |  |  |
| `DATA_TYPE` | `varchar2` | DATA_TYPE | [ ] |  |  |
| `DATETIME_PRECISION` | `int16` | DATETIME_PRECISION | [ ] |  |  |
| `IS_NULLABLE` | `varchar2` | IS_NULLABLE | [ ] |  |  |
| `MEMBER_DEFAULT` | `varchar2` | MEMBER_DEFAULT | [ ] |  |  |
| `MEMBER_NAME` | `varchar2` | MEMBER_NAME | [ ] |  |  |
| `NUMERIC_PRECISION` | `byte` | NUMERIC_PRECISION | [ ] |  |  |
| `NUMERIC_PRECISION_RADIX` | `int16` | NUMERIC_PRECISION_RADIX | [ ] |  |  |
| `NUMERIC_SCALE` | `int32` | NUMERIC_SCALE | [ ] |  |  |
| `ORDINAL_POSITION` | `int32` | ORDINAL_POSITION | [ ] |  |  |
| `TYPE_CATALOG` | `varchar2` | TYPE_CATALOG | [ ] |  |  |
| `TYPE_NAME` | `varchar2` | TYPE_NAME | [ ] |  |  |
| `TYPE_SCHEMA` | `varchar2` | TYPE_SCHEMA | [ ] |  |  |
