| APPL_FILE.PK_APPL_FILE |
| TableName | APPL_FILE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| APPL_FILE.PK_APPL_FILE Index Columns |
| ColumnName | Sort Order |
| APPL_FILE_ID | Ascending |
| APPL_FILE.PK_APPL_FILE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| APPL_FILE.PK_APPL_FILE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| APPL_FILE.PK_APPL_FILE Bound Attachments |
| Name | Current Value |
| ATTACH_TYPE.PK_ATTACH_TYPE |
| TableName | ATTACH_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ATTACH_TYPE.PK_ATTACH_TYPE Index Columns |
| ColumnName | Sort Order |
| ATTACH_TYPE_ID | Ascending |
| ATTACH_TYPE.PK_ATTACH_TYPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ATTACH_TYPE.PK_ATTACH_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ATTACH_TYPE.PK_ATTACH_TYPE Bound Attachments |
| Name | Current Value |
| BEAM_ENGY_UOM.PK_BEAM_ENGY_UOM |
| TableName | BEAM_ENGY_UOM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ENGY_UOM.PK_BEAM_ENGY_UOM Index Columns |
| ColumnName | Sort Order |
| BEAM_ENGY_UOM_ID | Ascending |
| BEAM_ENGY_UOM.PK_BEAM_ENGY_UOM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ENGY_UOM.PK_BEAM_ENGY_UOM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ENGY_UOM.PK_BEAM_ENGY_UOM Bound Attachments |
| Name | Current Value |
| CNTRY.PK_CNTRY |
| TableName | CNTRY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CNTRY.PK_CNTRY Index Columns |
| ColumnName | Sort Order |
| CNTRY_ID | Ascending |
| CNTRY.PK_CNTRY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CNTRY.PK_CNTRY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CNTRY.PK_CNTRY Bound Attachments |
| Name | Current Value |
| CTRL_AREA.PK_CTRL_AREA |
| TableName | CTRL_AREA |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA.PK_CTRL_AREA Index Columns |
| ColumnName | Sort Order |
| CTRL_AREA_ID | Ascending |
| CTRL_AREA.PK_CTRL_AREA Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA.PK_CTRL_AREA Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA.PK_CTRL_AREA Bound Attachments |
| Name | Current Value |
| CTRL_AREA_CUST.PK_CTRL_AREA_CUST |
| TableName | CTRL_AREA_CUST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA_CUST.PK_CTRL_AREA_CUST Index Columns |
| ColumnName | Sort Order |
| CTRL_AREA_ID | Ascending |
| BN | Ascending |
| CTRL_AREA_CUST.PK_CTRL_AREA_CUST Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA_CUST.PK_CTRL_AREA_CUST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA_CUST.PK_CTRL_AREA_CUST Bound Attachments |
| Name | Current Value |
| CTRL_AREA_INVT.PK_CTRL_AREA_INVT |
| TableName | CTRL_AREA_INVT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA_INVT.PK_CTRL_AREA_INVT Index Columns |
| ColumnName | Sort Order |
| CTRL_AREA_ID | Ascending |
| CUR_DTE | Ascending |
| CTRL_AREA_INVT.PK_CTRL_AREA_INVT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA_INVT.PK_CTRL_AREA_INVT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA_INVT.PK_CTRL_AREA_INVT Bound Attachments |
| Name | Current Value |
| CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA |
| TableName | CTRL_AREA_SUBAREA |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Index Columns |
| ColumnName | Sort Order |
| CTRL_AREA_ID | Ascending |
| SUBAREA_ID | Ascending |
| CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Bound Attachments |
| Name | Current Value |
| CTRL_AREA_SUBAREA1.PK_CTRL_AREA_SUBAREA1 |
| TableName | CTRL_AREA_SUBAREA1 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA_SUBAREA1.PK_CTRL_AREA_SUBAREA1 Index Columns |
| ColumnName | Sort Order |
| CTRL_AREA_ID | Ascending |
| SUBAREA_ID | Ascending |
| SUBAREA1_ID | Ascending |
| CTRL_AREA_SUBAREA1.PK_CTRL_AREA_SUBAREA1 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA_SUBAREA1.PK_CTRL_AREA_SUBAREA1 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA_SUBAREA1.PK_CTRL_AREA_SUBAREA1 Bound Attachments |
| Name | Current Value |
| CTRL_AREA_SUBAREA2.PK_CTRL_AREA_SUBAREA2 |
| TableName | CTRL_AREA_SUBAREA2 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA_SUBAREA2.PK_CTRL_AREA_SUBAREA2 Index Columns |
| ColumnName | Sort Order |
| CTRL_AREA_ID | Ascending |
| SUBAREA_ID | Ascending |
| SUBAREA1_ID | Ascending |
| SUBAREA2_ID | Ascending |
| CTRL_AREA_SUBAREA2.PK_CTRL_AREA_SUBAREA2 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA_SUBAREA2.PK_CTRL_AREA_SUBAREA2 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA_SUBAREA2.PK_CTRL_AREA_SUBAREA2 Bound Attachments |
| Name | Current Value |
| CTRL_AREA_TYPE.PK_CTRL_AREA_TYPE |
| TableName | CTRL_AREA_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CTRL_AREA_TYPE.PK_CTRL_AREA_TYPE Index Columns |
| ColumnName | Sort Order |
| TYPE_ID | Ascending |
| CTRL_AREA_TYPE.PK_CTRL_AREA_TYPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CTRL_AREA_TYPE.PK_CTRL_AREA_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CTRL_AREA_TYPE.PK_CTRL_AREA_TYPE Bound Attachments |
| Name | Current Value |
| DOT_HAZ_MAT_CLASS.PK_DOT_HAZ_MAT_CLASS |
| TableName | DOT_HAZ_MAT_CLASS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DOT_HAZ_MAT_CLASS.PK_DOT_HAZ_MAT_CLASS Index Columns |
| ColumnName | Sort Order |
| DOT_CLASS_NBR | Ascending |
| DOT_DIV_NBR | Ascending |
| DOT_HAZ_MAT_CLASS.PK_DOT_HAZ_MAT_CLASS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DOT_HAZ_MAT_CLASS.PK_DOT_HAZ_MAT_CLASS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DOT_HAZ_MAT_CLASS.PK_DOT_HAZ_MAT_CLASS Bound Attachments |
| Name | Current Value |
| DOT_HAZ_MAT_TAB.PK_DOT_HAZ_MAT_TAB |
| TableName | DOT_HAZ_MAT_TAB |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DOT_HAZ_MAT_TAB.PK_DOT_HAZ_MAT_TAB Index Columns |
| ColumnName | Sort Order |
| HAZ_MAT_ID | Ascending |
| DOT_HAZ_MAT_TAB.PK_DOT_HAZ_MAT_TAB Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DOT_HAZ_MAT_TAB.PK_DOT_HAZ_MAT_TAB Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DOT_HAZ_MAT_TAB.PK_DOT_HAZ_MAT_TAB Bound Attachments |
| Name | Current Value |
| DOT_PKG_GRP.PK_DOT_PKG_GRP |
| TableName | DOT_PKG_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DOT_PKG_GRP.PK_DOT_PKG_GRP Index Columns |
| ColumnName | Sort Order |
| PKG_GRP_ID | Ascending |
| DOT_PKG_GRP.PK_DOT_PKG_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DOT_PKG_GRP.PK_DOT_PKG_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DOT_PKG_GRP.PK_DOT_PKG_GRP Bound Attachments |
| Name | Current Value |
| 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 | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| 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 |
| HMMIS_CHEM.PK_CHEMICAL |
| TableName | HMMIS_CHEM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| HMMIS_CHEM.PK_CHEMICAL Index Columns |
| ColumnName | Sort Order |
| CHEM_RECID | Ascending |
| HMMIS_CHEM.PK_CHEMICAL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| HMMIS_CHEM.PK_CHEMICAL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| HMMIS_CHEM.PK_CHEMICAL Bound Attachments |
| Name | Current Value |
| HMMIS_MSDS.PK_HMMIS_MSDS |
| TableName | HMMIS_MSDS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| HMMIS_MSDS.PK_HMMIS_MSDS Index Columns |
| ColumnName | Sort Order |
| MSDS_RECID | Ascending |
| HMMIS_MSDS.PK_HMMIS_MSDS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| HMMIS_MSDS.PK_HMMIS_MSDS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| HMMIS_MSDS.PK_HMMIS_MSDS Bound Attachments |
| Name | Current Value |
| INSTR.PK_INSTR |
| TableName | INSTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR.PK_INSTR Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| INSTR.PK_INSTR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR.PK_INSTR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR.PK_INSTR Bound Attachments |
| Name | Current Value |
| ITEMS_LOG.PK_ITEMS_LOG |
| TableName | ITEMS_LOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ITEMS_LOG.PK_ITEMS_LOG Index Columns |
| ColumnName | Sort Order |
| ACT_ID | Ascending |
| MOD_DTE | Ascending |
| ITEMS_LOG.PK_ITEMS_LOG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ITEMS_LOG.PK_ITEMS_LOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ITEMS_LOG.PK_ITEMS_LOG Bound Attachments |
| Name | Current Value |
| LAB.PK_LAB |
| TableName | LAB |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| LAB.PK_LAB Index Columns |
| ColumnName | Sort Order |
| LAB_ID | Ascending |
| LAB.PK_LAB Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| LAB.PK_LAB Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| LAB.PK_LAB Bound Attachments |
| Name | Current Value |
| MATL_ST.PK_MATL_ST |
| TableName | MATL_ST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MATL_ST.PK_MATL_ST Index Columns |
| ColumnName | Sort Order |
| ST_ID | Ascending |
| MATL_ST.PK_MATL_ST Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MATL_ST.PK_MATL_ST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MATL_ST.PK_MATL_ST Bound Attachments |
| Name | Current Value |
| PROPOSAL.PK_PROPOSAL |
| TableName | PROPOSAL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PROPOSAL.PK_PROPOSAL Index Columns |
| ColumnName | Sort Order |
| PRPSL_ID | Ascending |
| PROPOSAL.PK_PROPOSAL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PROPOSAL.PK_PROPOSAL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PROPOSAL.PK_PROPOSAL Bound Attachments |
| Name | Current Value |
| PROPOSAL.PROPOSAL_SOR_INDEX |
| TableName | PROPOSAL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PRPSL.PROPOSAL_SOR_INDEX ON PRPSL.PROPOSAL(STMT_OF_RESCH) LOGGING ; |
| PROPOSAL.PROPOSAL_SOR_INDEX Index Columns |
| ColumnName | Sort Order |
| STMT_OF_RESCH | Ascending |
| PROPOSAL.PROPOSAL_SOR_INDEX Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PROPOSAL.PROPOSAL_SOR_INDEX Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PROPOSAL.PROPOSAL_SOR_INDEX Bound Attachments |
| Name | Current Value |
| PROPOSAL.IDX_PRPSL_STAT_IND |
| TableName | PROPOSAL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PRPSL.IDX_PRPSL_STAT_IND ON PRPSL.PROPOSAL(PRPSL_ID, STAT_ID) LOGGING ; |
| PROPOSAL.IDX_PRPSL_STAT_IND Index Columns |
| ColumnName | Sort Order |
| PRPSL_ID | Ascending |
| STAT_ID | Ascending |
| PROPOSAL.IDX_PRPSL_STAT_IND Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PROPOSAL.IDX_PRPSL_STAT_IND Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PROPOSAL.IDX_PRPSL_STAT_IND Bound Attachments |
| Name | Current Value |
| PROPOSAL.FK_PRPSL_PRPSL_STAT |
| TableName | PROPOSAL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PRPSL.FK_PRPSL_PRPSL_STAT ON PRPSL.PROPOSAL(STAT_ID) LOGGING ; |
| PROPOSAL.FK_PRPSL_PRPSL_STAT Index Columns |
| ColumnName | Sort Order |
| STAT_ID | Ascending |
| PROPOSAL.FK_PRPSL_PRPSL_STAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PROPOSAL.FK_PRPSL_PRPSL_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PROPOSAL.FK_PRPSL_PRPSL_STAT Bound Attachments |
| Name | Current Value |
| PROPOSAL.FK_PRPSL_USR_CAT |
| TableName | PROPOSAL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX PRPSL.FK_PRPSL_USR_CAT ON PRPSL.PROPOSAL(PRPSL_TYPE_ID) LOGGING ; |
| PROPOSAL.FK_PRPSL_USR_CAT Index Columns |
| ColumnName | Sort Order |
| PRPSL_TYPE_ID | Ascending |
| PROPOSAL.FK_PRPSL_USR_CAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PROPOSAL.FK_PRPSL_USR_CAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PROPOSAL.FK_PRPSL_USR_CAT Bound Attachments |
| Name | Current Value |
| RADIONUC.PK_RADIONUC |
| TableName | RADIONUC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RADIONUC.PK_RADIONUC Index Columns |
| ColumnName | Sort Order |
| SYM_ID | Ascending |
| RADIONUC.PK_RADIONUC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RADIONUC.PK_RADIONUC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RADIONUC.PK_RADIONUC Bound Attachments |
| Name | Current Value |
| RFID_PRINTER.PK_RFID_PRINTER |
| TableName | RFID_PRINTER |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RFID_PRINTER.PK_RFID_PRINTER Index Columns |
| ColumnName | Sort Order |
| PRINT_ID | Ascending |
| RFID_PRINTER.PK_RFID_PRINTER Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RFID_PRINTER.PK_RFID_PRINTER Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RFID_PRINTER.PK_RFID_PRINTER Bound Attachments |
| Name | Current Value |
| SAMPLE.PK_SAMPLE |
| TableName | SAMPLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SAMPLE.PK_SAMPLE Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SAMPLE.PK_SAMPLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SAMPLE.PK_SAMPLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SAMPLE.PK_SAMPLE Bound Attachments |
| Name | Current Value |
| SAMPLE_SMPL_ATTACH_ASSC.PK_SAMPLE_SMPL_ATTACH_ASSC |
| TableName | SAMPLE_SMPL_ATTACH_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SAMPLE_SMPL_ATTACH_ASSC.PK_SAMPLE_SMPL_ATTACH_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| ATTACH_ID | Ascending |
| SAMPLE_SMPL_ATTACH_ASSC.PK_SAMPLE_SMPL_ATTACH_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SAMPLE_SMPL_ATTACH_ASSC.PK_SAMPLE_SMPL_ATTACH_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SAMPLE_SMPL_ATTACH_ASSC.PK_SAMPLE_SMPL_ATTACH_ASSC Bound Attachments |
| Name | Current Value |
| SHIP_FACIL.PK_SHIP_FACIL |
| TableName | SHIP_FACIL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIP_FACIL.PK_SHIP_FACIL Index Columns |
| ColumnName | Sort Order |
| SHIP_FACIL_ID | Ascending |
| SHIP_FACIL.PK_SHIP_FACIL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SHIP_FACIL.PK_SHIP_FACIL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIP_FACIL.PK_SHIP_FACIL Bound Attachments |
| Name | Current Value |
| SMPL_ACT.PK_SMPL_ACT |
| TableName | SMPL_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ACT.PK_SMPL_ACT Index Columns |
| ColumnName | Sort Order |
| ACT_ID | Ascending |
| SMPL_ACT.PK_SMPL_ACT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ACT.PK_SMPL_ACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ACT.PK_SMPL_ACT Bound Attachments |
| Name | Current Value |
| SMPL_ATTACH.PK_SMPL_ATTACH |
| TableName | SMPL_ATTACH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ATTACH.PK_SMPL_ATTACH Index Columns |
| ColumnName | Sort Order |
| ATTACH_ID | Ascending |
| SMPL_ATTACH.PK_SMPL_ATTACH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ATTACH.PK_SMPL_ATTACH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ATTACH.PK_SMPL_ATTACH Bound Attachments |
| Name | Current Value |
| SMPL_CAN.PK_SMPL_CAN |
| TableName | SMPL_CAN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_CAN.PK_SMPL_CAN Index Columns |
| ColumnName | Sort Order |
| CAN_ID | Ascending |
| CONT_ID | Ascending |
| SMPL_CAN.PK_SMPL_CAN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_CAN.PK_SMPL_CAN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_CAN.PK_SMPL_CAN Bound Attachments |
| Name | Current Value |
| SMPL_CLASS.PK_SMPL_CLASS |
| TableName | SMPL_CLASS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_CLASS.PK_SMPL_CLASS Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SMPL_CLASS_ID | Ascending |
| SMPL_CLASS.PK_SMPL_CLASS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_CLASS.PK_SMPL_CLASS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_CLASS.PK_SMPL_CLASS Bound Attachments |
| Name | Current Value |
| SMPL_CONT.PK_SMPL_CONT |
| TableName | SMPL_CONT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_CONT.PK_SMPL_CONT Index Columns |
| ColumnName | Sort Order |
| CONT_ID | Ascending |
| SMPL_CONT.PK_SMPL_CONT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_CONT.PK_SMPL_CONT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_CONT.PK_SMPL_CONT Bound Attachments |
| Name | Current Value |
| SMPL_DEL_REQ.PK_SMPL_DEL_REQ |
| TableName | SMPL_DEL_REQ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_DEL_REQ.PK_SMPL_DEL_REQ Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SMPL_DEL_REQ.PK_SMPL_DEL_REQ Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_DEL_REQ.PK_SMPL_DEL_REQ Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_DEL_REQ.PK_SMPL_DEL_REQ Bound Attachments |
| Name | Current Value |
| SMPL_DELIV_REQ.PK_SMPL_DELIV_REQ |
| TableName | SMPL_DELIV_REQ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_DELIV_REQ.PK_SMPL_DELIV_REQ Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SMPL_DELIV_REQ.PK_SMPL_DELIV_REQ Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_DELIV_REQ.PK_SMPL_DELIV_REQ Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_DELIV_REQ.PK_SMPL_DELIV_REQ Bound Attachments |
| Name | Current Value |
| SMPL_FORM.PK_SMPL_FORM |
| TableName | SMPL_FORM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_FORM.PK_SMPL_FORM Index Columns |
| ColumnName | Sort Order |
| SMPL_FORM_ID | Ascending |
| SMPL_FORM.PK_SMPL_FORM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_FORM.PK_SMPL_FORM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_FORM.PK_SMPL_FORM Bound Attachments |
| Name | Current Value |
| SMPL_GRP.PK_SMPL_GRP |
| TableName | SMPL_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_GRP.PK_SMPL_GRP Index Columns |
| ColumnName | Sort Order |
| GRP_ID | Ascending |
| SMPL_GRP.PK_SMPL_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_GRP.PK_SMPL_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_GRP.PK_SMPL_GRP Bound Attachments |
| Name | Current Value |
| SMPL_HAND.PK_SMPL_HAND |
| TableName | SMPL_HAND |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_HAND.PK_SMPL_HAND Index Columns |
| ColumnName | Sort Order |
| HAND_ID | Ascending |
| SMPL_HAND.PK_SMPL_HAND Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_HAND.PK_SMPL_HAND Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_HAND.PK_SMPL_HAND Bound Attachments |
| Name | Current Value |
| SMPL_HAZ.PK_SMPL_HAZ |
| TableName | SMPL_HAZ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_HAZ.PK_SMPL_HAZ Index Columns |
| ColumnName | Sort Order |
| SMPL_HAZ_ID | Ascending |
| SMPL_HAZ.PK_SMPL_HAZ Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_HAZ.PK_SMPL_HAZ Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_HAZ.PK_SMPL_HAZ Bound Attachments |
| Name | Current Value |
| SMPL_HAZ_CLASS.PK_SMPL_HAZ_CLASS |
| TableName | SMPL_HAZ_CLASS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_HAZ_CLASS.PK_SMPL_HAZ_CLASS Index Columns |
| ColumnName | Sort Order |
| SMPL_HAZ_ID | Ascending |
| SMPL_HAZ_CLASS.PK_SMPL_HAZ_CLASS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_HAZ_CLASS.PK_SMPL_HAZ_CLASS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_HAZ_CLASS.PK_SMPL_HAZ_CLASS Bound Attachments |
| Name | Current Value |
| SMPL_HAZ_CLASS_ITEM.PK_SMPL_HAZ_CLASS_ITEM |
| TableName | SMPL_HAZ_CLASS_ITEM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_HAZ_CLASS_ITEM.PK_SMPL_HAZ_CLASS_ITEM Index Columns |
| ColumnName | Sort Order |
| SMPL_HAZ_ID | Ascending |
| CLASS_ID | Ascending |
| SMPL_HAZ_CLASS_ITEM.PK_SMPL_HAZ_CLASS_ITEM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_HAZ_CLASS_ITEM.PK_SMPL_HAZ_CLASS_ITEM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_HAZ_CLASS_ITEM.PK_SMPL_HAZ_CLASS_ITEM Bound Attachments |
| Name | Current Value |
| SMPL_HAZ_GRP.PK_SMPL_HAZ_GRP |
| TableName | SMPL_HAZ_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_HAZ_GRP.PK_SMPL_HAZ_GRP Index Columns |
| ColumnName | Sort Order |
| SMPL_HAZ_GRP_ID | Ascending |
| SMPL_HAZ_GRP.PK_SMPL_HAZ_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_HAZ_GRP.PK_SMPL_HAZ_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_HAZ_GRP.PK_SMPL_HAZ_GRP Bound Attachments |
| Name | Current Value |
| SMPL_IRRAD.PK_SMPL_IRRAD |
| TableName | SMPL_IRRAD |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_IRRAD.PK_SMPL_IRRAD Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| INSTR_ID | Ascending |
| RMV_BEAM_DTE | Ascending |
| SMPL_IRRAD.PK_SMPL_IRRAD Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_IRRAD.PK_SMPL_IRRAD Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_IRRAD.PK_SMPL_IRRAD Bound Attachments |
| Name | Current Value |
| SMPL_LOG.PK_SMPL_LOG |
| TableName | SMPL_LOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_LOG.PK_SMPL_LOG Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| ACT_ID | Ascending |
| CUR_DTE | Ascending |
| SMPL_LOG.PK_SMPL_LOG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_LOG.PK_SMPL_LOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_LOG.PK_SMPL_LOG Bound Attachments |
| Name | Current Value |
| SMPL_PRPSL_ASSC.PK_SMPL_PRPSL_ASSC |
| TableName | SMPL_PRPSL_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_PRPSL_ASSC.PK_SMPL_PRPSL_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| PRPSL_ID | Ascending |
| SMPL_PRPSL_ASSC.PK_SMPL_PRPSL_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_PRPSL_ASSC.PK_SMPL_PRPSL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_PRPSL_ASSC.PK_SMPL_PRPSL_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_RADIONUC_ASSC.PK_SMPL_RADIONUC_ASSC |
| TableName | SMPL_RADIONUC_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_RADIONUC_ASSC.PK_SMPL_RADIONUC_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SYM_ID | Ascending |
| SMPL_RADIONUC_ASSC.PK_SMPL_RADIONUC_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_RADIONUC_ASSC.PK_SMPL_RADIONUC_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_RADIONUC_ASSC.PK_SMPL_RADIONUC_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_ROLE.PK_SMPL_ROLE |
| TableName | SMPL_ROLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ROLE.PK_SMPL_ROLE Index Columns |
| ColumnName | Sort Order |
| ROLE_ID | Ascending |
| SMPL_ROLE.PK_SMPL_ROLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ROLE.PK_SMPL_ROLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ROLE.PK_SMPL_ROLE Bound Attachments |
| Name | Current Value |
| SMPL_ROLE_EMP_ASSC.PK_SMPL_ROLE_PERS_ASSC |
| TableName | SMPL_ROLE_EMP_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ROLE_EMP_ASSC.PK_SMPL_ROLE_PERS_ASSC Index Columns |
| ColumnName | Sort Order |
| ROLE_ID | Ascending |
| BN | Ascending |
| SMPL_ROLE_EMP_ASSC.PK_SMPL_ROLE_PERS_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ROLE_EMP_ASSC.PK_SMPL_ROLE_PERS_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ROLE_EMP_ASSC.PK_SMPL_ROLE_PERS_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_ROLE_EMP_CTRL_AREA_ASSC.PK_SMPL_ROLE_EMP_CTRL_AREA_ASS |
| TableName | SMPL_ROLE_EMP_CTRL_AREA_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ROLE_EMP_CTRL_AREA_ASSC.PK_SMPL_ROLE_EMP_CTRL_AREA_ASS Index Columns |
| ColumnName | Sort Order |
| ROLE_ID | Ascending |
| BN | Ascending |
| CTRL_AREA_ID | Ascending |
| SMPL_ROLE_EMP_CTRL_AREA_ASSC.PK_SMPL_ROLE_EMP_CTRL_AREA_ASS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ROLE_EMP_CTRL_AREA_ASSC.PK_SMPL_ROLE_EMP_CTRL_AREA_ASS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ROLE_EMP_CTRL_AREA_ASSC.PK_SMPL_ROLE_EMP_CTRL_AREA_ASS Bound Attachments |
| Name | Current Value |
| SMPL_ROLE_GRP.PK_SMPL_ROLE_GRP |
| TableName | SMPL_ROLE_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ROLE_GRP.PK_SMPL_ROLE_GRP Index Columns |
| ColumnName | Sort Order |
| SMPL_ROLE_GRP_ID | Ascending |
| SMPL_ROLE_GRP.PK_SMPL_ROLE_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ROLE_GRP.PK_SMPL_ROLE_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ROLE_GRP.PK_SMPL_ROLE_GRP Bound Attachments |
| Name | Current Value |
| SMPL_ROLE_TMPL.PK_SMPL_ROLE_TMPL |
| TableName | SMPL_ROLE_TMPL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ROLE_TMPL.PK_SMPL_ROLE_TMPL Index Columns |
| ColumnName | Sort Order |
| SMPL_ROLE_GRP_ID | Ascending |
| ROLE_ID | Ascending |
| SMPL_ROLE_TMPL.PK_SMPL_ROLE_TMPL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ROLE_TMPL.PK_SMPL_ROLE_TMPL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ROLE_TMPL.PK_SMPL_ROLE_TMPL Bound Attachments |
| Name | Current Value |
| SMPL_SET_TEMP.PK_SMPL_SET_TEMP |
| TableName | SMPL_SET_TEMP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SET_TEMP.PK_SMPL_SET_TEMP Index Columns |
| ColumnName | Sort Order |
| SMPL_SET_ID | Ascending |
| SMPL_ID | Ascending |
| SMPL_SET_TEMP.PK_SMPL_SET_TEMP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SET_TEMP.PK_SMPL_SET_TEMP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SET_TEMP.PK_SMPL_SET_TEMP Bound Attachments |
| Name | Current Value |
| SMPL_SHIP.PK_SMPL_SHIP |
| TableName | SMPL_SHIP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SHIP.PK_SMPL_SHIP Index Columns |
| ColumnName | Sort Order |
| SMPL_SHIP_ID | Ascending |
| SMPL_SHIP.PK_SMPL_SHIP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SHIP.PK_SMPL_SHIP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SHIP.PK_SMPL_SHIP Bound Attachments |
| Name | Current Value |
| SMPL_SHIP_ATTACH.PK_SMPL_SHIP_ATTACH |
| TableName | SMPL_SHIP_ATTACH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SHIP_ATTACH.PK_SMPL_SHIP_ATTACH Index Columns |
| ColumnName | Sort Order |
| SMPL_SHIP_ID | Ascending |
| ATTACH_ID | Ascending |
| SMPL_SHIP_ATTACH.PK_SMPL_SHIP_ATTACH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SHIP_ATTACH.PK_SMPL_SHIP_ATTACH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SHIP_ATTACH.PK_SMPL_SHIP_ATTACH Bound Attachments |
| Name | Current Value |
| SMPL_SHIP_SMPL_ATTCH_ASSC.PK_SMPL_SHIP_SMPL_ATTCH_ASSC |
| TableName | SMPL_SHIP_SMPL_ATTCH_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SHIP_SMPL_ATTCH_ASSC.PK_SMPL_SHIP_SMPL_ATTCH_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_SHIP_ID | Ascending |
| ATTACH_ID | Ascending |
| SMPL_SHIP_SMPL_ATTCH_ASSC.PK_SMPL_SHIP_SMPL_ATTCH_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SHIP_SMPL_ATTCH_ASSC.PK_SMPL_SHIP_SMPL_ATTCH_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SHIP_SMPL_ATTCH_ASSC.PK_SMPL_SHIP_SMPL_ATTCH_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_SHIP_STAT.PK_SMPL_SHIP_STAT |
| TableName | SMPL_SHIP_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SHIP_STAT.PK_SMPL_SHIP_STAT Index Columns |
| ColumnName | Sort Order |
| STAT_ID | Ascending |
| SMPL_SHIP_STAT.PK_SMPL_SHIP_STAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SHIP_STAT.PK_SMPL_SHIP_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SHIP_STAT.PK_SMPL_SHIP_STAT Bound Attachments |
| Name | Current Value |
| SMPL_SMPL_FORM_ASSC.PK_SMPL_SMPL_FORM_ASSC |
| TableName | SMPL_SMPL_FORM_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SMPL_FORM_ASSC.PK_SMPL_SMPL_FORM_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SMPL_FORM_ID | Ascending |
| SMPL_SMPL_FORM_ASSC.PK_SMPL_SMPL_FORM_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SMPL_FORM_ASSC.PK_SMPL_SMPL_FORM_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SMPL_FORM_ASSC.PK_SMPL_SMPL_FORM_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_SMPL_SHIP_ASSC.PK_SMPL_SMPL_SHIP_ASSC |
| TableName | SMPL_SMPL_SHIP_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SMPL_SHIP_ASSC.PK_SMPL_SMPL_SHIP_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| SMPL_SHIP_ID | Ascending |
| SMPL_SMPL_SHIP_ASSC.PK_SMPL_SMPL_SHIP_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SMPL_SHIP_ASSC.PK_SMPL_SMPL_SHIP_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SMPL_SHIP_ASSC.PK_SMPL_SMPL_SHIP_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_SPEC_REQ.PK_SMPL_SPEC_REQ |
| TableName | SMPL_SPEC_REQ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SPEC_REQ.PK_SMPL_SPEC_REQ Index Columns |
| ColumnName | Sort Order |
| REQ_ID | Ascending |
| SMPL_SPEC_REQ.PK_SMPL_SPEC_REQ Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SPEC_REQ.PK_SMPL_SPEC_REQ Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SPEC_REQ.PK_SMPL_SPEC_REQ Bound Attachments |
| Name | Current Value |
| SMPL_SPEC_REQ_ASSC.PK_SMPL_SPEC_REQ_ASSC |
| TableName | SMPL_SPEC_REQ_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SPEC_REQ_ASSC.PK_SMPL_SPEC_REQ_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| REQ_ID | Ascending |
| SMPL_SPEC_REQ_ASSC.PK_SMPL_SPEC_REQ_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SPEC_REQ_ASSC.PK_SMPL_SPEC_REQ_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SPEC_REQ_ASSC.PK_SMPL_SPEC_REQ_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_STAT.PK_SMPL_STAT |
| TableName | SMPL_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_STAT.PK_SMPL_STAT Index Columns |
| ColumnName | Sort Order |
| STAT_ID | Ascending |
| SMPL_STAT.PK_SMPL_STAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_STAT.PK_SMPL_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_STAT.PK_SMPL_STAT Bound Attachments |
| Name | Current Value |
| SMPL_STOR.PK_SMPL_STOR |
| TableName | SMPL_STOR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_STOR.PK_SMPL_STOR Index Columns |
| ColumnName | Sort Order |
| STOR_ID | Ascending |
| SMPL_STOR.PK_SMPL_STOR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_STOR.PK_SMPL_STOR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_STOR.PK_SMPL_STOR Bound Attachments |
| Name | Current Value |
| SMPL_TRANS.PK_SMPL_TRANS |
| TableName | SMPL_TRANS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_TRANS.PK_SMPL_TRANS Index Columns |
| ColumnName | Sort Order |
| SMPL_ID | Ascending |
| CTRL_AREA_ID | Ascending |
| SUBAREA_ID | Ascending |
| CUR_DTE | Ascending |
| SMPL_TRANS.PK_SMPL_TRANS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_TRANS.PK_SMPL_TRANS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_TRANS.PK_SMPL_TRANS Bound Attachments |
| Name | Current Value |
| TIME_UOM.PK_TIME_UOM |
| TableName | TIME_UOM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| TIME_UOM.PK_TIME_UOM Index Columns |
| ColumnName | Sort Order |
| TIME_UNIT_ID | Ascending |
| TIME_UOM.PK_TIME_UOM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| TIME_UOM.PK_TIME_UOM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| TIME_UOM.PK_TIME_UOM Bound Attachments |
| Name | Current Value |
| UNIT_LEN.PK_UNIT_LEN |
| TableName | UNIT_LEN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UNIT_LEN.PK_UNIT_LEN Index Columns |
| ColumnName | Sort Order |
| LEN_UNIT_ID | Ascending |
| UNIT_LEN.PK_UNIT_LEN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| UNIT_LEN.PK_UNIT_LEN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UNIT_LEN.PK_UNIT_LEN Bound Attachments |
| Name | Current Value |
| USER_PROFILE.PK_USER_PROFILE |
| TableName | USER_PROFILE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| USER_PROFILE.PK_USER_PROFILE Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| USER_PROFILE.PK_USER_PROFILE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| USER_PROFILE.PK_USER_PROFILE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| USER_PROFILE.PK_USER_PROFILE Bound Attachments |
| Name | Current Value |