invantive documentation
Invantive Support ForumsLog In / Sign Up

StructuredTypeMembers: SQL Server

read only

  • Catalog: Database
  • Schema: Metadata

Can only retrieve data.

Table Columns

The columns of the table StructuredTypeMembers 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
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