SYSTEMTABLEKEYS: Data Dictionary Table Keys
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: Table Keys
Primary and unique keys per table per data container, one row per column of a key.
Solo puede recuperar datos.
Resumen
Lists the keys the driver knows of the tables it has loaded the metadata of. The guarantee tells whether the engine may trust a key to leave out a join: 'Declared' keys are shown but not relied upon.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMTABLEKEYS. 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 |
|---|---|---|---|---|---|
COLUMN_ |
varchar2 |
Nombre de la Columna | Name of the column. | ||
COLUMN_ |
int32 |
Posición de la Columna | Position of the column within the key, starting at 1. | ||
ID |
int32 |
ID | Unique ID of the row. | ||
KEY_ |
int32 |
Columns | Number of columns of the key. | ||
KEY_ |
varchar2 |
Key Status | What holds the key: 'Declared' (not relied upon), 'Enforced' or 'EnforcedIgnoringTrailingBlanks' (enforced, comparing texts without their trailing blanks). | ||
KEY_ |
varchar2 |
Key Name | Name of the key, when known. | ||
KEY_ |
varchar2 |
Key Type | Type of the key: 'primary' or 'unique'. | ||
PROVIDER_ |
varchar2 |
Alias del Contenedor de Datos | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID del Contenedor de Datos | Data container ID. | ||
PROVIDER_ |
varchar2 |
Descripción del proveedor | Provider description. | ||
PROVIDER_ |
guid |
UID de instancia de proveedor | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nombre del Proveedor | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nombre abreviado del proveedor | Provider short name. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
varchar2 |
Tabla: Nombre completo y completo | Full qualified name. | ||
TABLE_ |
varchar2 |
Nombre de la Tabla | Name of the table or view. | ||
TABLE_ |
varchar2 |
Table Schema | Schema within the catalog where the table is contained in. | ||
TABLE_ |
varchar2 |
Tipo de tabla | Type, can be either 'view' or 'table'. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLEKEYS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLEKEYS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEKEYS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEKEYS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEKEYS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: