| EMPLOYEE.PK_EMPLOYEE |
| TableName | EMPLOYEE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMPLOYEE.PK_EMPLOYEE Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| EMPLOYEE.PK_EMPLOYEE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMPLOYEE.PK_EMPLOYEE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMPLOYEE.PK_EMPLOYEE Bound Attachments |
| Name | Current Value |
| ICS_APPL_SFTW.PK_ICS_APPL_SFTW |
| TableName | ICS_APPL_SFTW |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_APPL_SFTW.PK_ICS_APPL_SFTW Index Columns |
| ColumnName | Sort Order |
| APPL_NM | Ascending |
| ICS_APPL_SFTW.PK_ICS_APPL_SFTW Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_APPL_SFTW.PK_ICS_APPL_SFTW Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_APPL_SFTW.PK_ICS_APPL_SFTW Bound Attachments |
| Name | Current Value |
| ICS_APPL_SFTW.FK_SFTW_APPL_EMPLOYEE |
| TableName | ICS_APPL_SFTW |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_APPL_EMPLOYEE ON CONT.ICS_APPL_SFTW(SFTW_MAINT_BN) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_APPL_SFTW.FK_SFTW_APPL_EMPLOYEE Index Columns |
| ColumnName | Sort Order |
| SFTW_MAINT_BN | Ascending |
| ICS_APPL_SFTW.FK_SFTW_APPL_EMPLOYEE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_APPL_SFTW.FK_SFTW_APPL_EMPLOYEE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_APPL_SFTW.FK_SFTW_APPL_EMPLOYEE Bound Attachments |
| Name | Current Value |
| ICS_APPL_SFTW.FK_SFTW_APPL_SRV |
| TableName | ICS_APPL_SFTW |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_APPL_SRV ON CONT.ICS_APPL_SFTW(SRV_NM) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_APPL_SFTW.FK_SFTW_APPL_SRV Index Columns |
| ColumnName | Sort Order |
| SRV_NM | Ascending |
| ICS_APPL_SFTW.FK_SFTW_APPL_SRV Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_APPL_SFTW.FK_SFTW_APPL_SRV Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_APPL_SFTW.FK_SFTW_APPL_SRV Bound Attachments |
| Name | Current Value |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_INPUT |
| TableName | ICS_APPL_SFTW |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_APPL_DATA_INPUT ON CONT.ICS_APPL_SFTW(DATA_INPUT_REPOS_ID) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_INPUT Index Columns |
| ColumnName | Sort Order |
| DATA_INPUT_REPOS_ID | Ascending |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_INPUT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_INPUT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_INPUT Bound Attachments |
| Name | Current Value |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_OUTPUT |
| TableName | ICS_APPL_SFTW |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_APPL_DATA_OUTPUT ON CONT.ICS_APPL_SFTW(DATA_OUPUT_REPOS_ID) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_OUTPUT Index Columns |
| ColumnName | Sort Order |
| DATA_OUPUT_REPOS_ID | Ascending |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_OUTPUT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_OUTPUT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_APPL_SFTW.FK_SFTW_APPL_DATA_OUTPUT Bound Attachments |
| Name | Current Value |
| ICS_APPL_SFTW.FK_SFTW_APPL_USER_INTFC |
| TableName | ICS_APPL_SFTW |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_APPL_USER_INTFC ON CONT.ICS_APPL_SFTW(USER_INTFC_ID) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_APPL_SFTW.FK_SFTW_APPL_USER_INTFC Index Columns |
| ColumnName | Sort Order |
| USER_INTFC_ID | Ascending |
| ICS_APPL_SFTW.FK_SFTW_APPL_USER_INTFC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_APPL_SFTW.FK_SFTW_APPL_USER_INTFC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_APPL_SFTW.FK_SFTW_APPL_USER_INTFC Bound Attachments |
| Name | Current Value |
| ICS_DATA_REPOS.PK_ICS_DATA_REPOS |
| TableName | ICS_DATA_REPOS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_DATA_REPOS.PK_ICS_DATA_REPOS Index Columns |
| ColumnName | Sort Order |
| REPOS_ID | Ascending |
| ICS_DATA_REPOS.PK_ICS_DATA_REPOS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_DATA_REPOS.PK_ICS_DATA_REPOS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_DATA_REPOS.PK_ICS_DATA_REPOS Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_ACCESS.PK_ICS_SFTW_ACCESS |
| TableName | ICS_SFTW_APPL_ACCESS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_SFTW_APPL_ACCESS.PK_ICS_SFTW_ACCESS Index Columns |
| ColumnName | Sort Order |
| ACCESS_ID | Ascending |
| ICS_SFTW_APPL_ACCESS.PK_ICS_SFTW_ACCESS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_ACCESS.PK_ICS_SFTW_ACCESS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_ACCESS.PK_ICS_SFTW_ACCESS Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_ASSC.PK_ICS_SFTW_APPL_ASSC |
| TableName | ICS_SFTW_APPL_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_SFTW_APPL_ASSC.PK_ICS_SFTW_APPL_ASSC Index Columns |
| ColumnName | Sort Order |
| APPL_NM | Ascending |
| ACCESS_ID | Ascending |
| ICS_SFTW_APPL_ASSC.PK_ICS_SFTW_APPL_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_ASSC.PK_ICS_SFTW_APPL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_ASSC.PK_ICS_SFTW_APPL_ASSC Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACCESS_ASSC_SFTW_APPL |
| TableName | ICS_SFTW_APPL_ASSC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_ACCESS_ASSC_SFTW_APPL ON CONT.ICS_SFTW_APPL_ASSC(APPL_NM) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACCESS_ASSC_SFTW_APPL Index Columns |
| ColumnName | Sort Order |
| APPL_NM | Ascending |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACCESS_ASSC_SFTW_APPL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACCESS_ASSC_SFTW_APPL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACCESS_ASSC_SFTW_APPL Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACC_ASSC_USER_ACC |
| TableName | ICS_SFTW_APPL_ASSC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_ACC_ASSC_USER_ACC ON CONT.ICS_SFTW_APPL_ASSC(ACCESS_ID) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACC_ASSC_USER_ACC Index Columns |
| ColumnName | Sort Order |
| ACCESS_ID | Ascending |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACC_ASSC_USER_ACC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACC_ASSC_USER_ACC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_ASSC.FK_SFTW_ACC_ASSC_USER_ACC Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_LANG_ASSC.PK_ICS_SFTW_APPL_LANG |
| TableName | ICS_SFTW_APPL_LANG_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_SFTW_APPL_LANG_ASSC.PK_ICS_SFTW_APPL_LANG Index Columns |
| ColumnName | Sort Order |
| APPL_NM | Ascending |
| LANG_NM | Ascending |
| ICS_SFTW_APPL_LANG_ASSC.PK_ICS_SFTW_APPL_LANG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_LANG_ASSC.PK_ICS_SFTW_APPL_LANG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_LANG_ASSC.PK_ICS_SFTW_APPL_LANG Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_APPL |
| TableName | ICS_SFTW_APPL_LANG_ASSC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_ASSC_APPL ON CONT.ICS_SFTW_APPL_LANG_ASSC(APPL_NM) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_APPL Index Columns |
| ColumnName | Sort Order |
| APPL_NM | Ascending |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_APPL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_APPL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_APPL Bound Attachments |
| Name | Current Value |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_LANG |
| TableName | ICS_SFTW_APPL_LANG_ASSC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX CONT.FK_SFTW_ASSC_LANG ON CONT.ICS_SFTW_APPL_LANG_ASSC(LANG_NM) PCTFREE 0 TABLESPACE CONT_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_LANG Index Columns |
| ColumnName | Sort Order |
| LANG_NM | Ascending |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_LANG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_LANG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_APPL_LANG_ASSC.FK_SFTW_ASSC_LANG Bound Attachments |
| Name | Current Value |
| ICS_SFTW_LANG.PK_ICS_SFTW_LANG |
| TableName | ICS_SFTW_LANG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_SFTW_LANG.PK_ICS_SFTW_LANG Index Columns |
| ColumnName | Sort Order |
| LANG_NM | Ascending |
| ICS_SFTW_LANG.PK_ICS_SFTW_LANG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SFTW_LANG.PK_ICS_SFTW_LANG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SFTW_LANG.PK_ICS_SFTW_LANG Bound Attachments |
| Name | Current Value |
| ICS_SRV.PK_ICS_SRV |
| TableName | ICS_SRV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_SRV.PK_ICS_SRV Index Columns |
| ColumnName | Sort Order |
| SRV_NM | Ascending |
| ICS_SRV.PK_ICS_SRV Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_SRV.PK_ICS_SRV Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_SRV.PK_ICS_SRV Bound Attachments |
| Name | Current Value |
| ICS_USER_INTFC.PK_ICS_USER_INTFC |
| TableName | ICS_USER_INTFC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ICS_USER_INTFC.PK_ICS_USER_INTFC Index Columns |
| ColumnName | Sort Order |
| USER_INTFC_ID | Ascending |
| ICS_USER_INTFC.PK_ICS_USER_INTFC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | CONT_INDEX_TS |
| PctFree | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ICS_USER_INTFC.PK_ICS_USER_INTFC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ICS_USER_INTFC.PK_ICS_USER_INTFC Bound Attachments |
| Name | Current Value |