SDC table

Structure Utility.Additional Column

Defines user-defined columns. Master table: SDK.

SDC_KEY NUMBER(19,0) not null
SDK_KEY NUMBER(19,0) not null
SDC_NAME VARCHAR2(30 CHAR) not null
SDC_VARIANT_TYPE VARCHAR2(10 CHAR) not null
SDC_SQL_LENGTH NUMBER(5,0)
SDC_LABEL VARCHAR2(100 CHAR)
SDC_FIELD_TYPE VARCHAR2(25 CHAR)
SDC_ORDER NUMBER(5,0)
SDC_DEFAULT VARCHAR2(1 CHAR)
SDC_DEFAULT_VALUE VARCHAR2(1000 CHAR)
SDC_PROFILE_ENABLED VARCHAR2(1 CHAR)
SDC_ENCRYPTED VARCHAR2(1 CHAR)
SDC_VERSION NUMBER(10,0)
SDC_DATA_LEVEL NUMBER(1,0)
SDC_CREATE DATE
SDC_CREATEBY NUMBER(19,0)
SDC_UPDATE DATE
SDC_UPDATEBY NUMBER(19,0)
SDC_NOTE CLOB
SDC_ROWVER RAW(8)

Child tables:

  1. SDP - User defined column properties
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License