INST_APP.INSTR_APP_PK |
TableName | INST_APP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INST_APP.INSTR_APP_PK Index Columns |
ColumnName | Sort Order |
APP_ID | Ascending |
INST_APP.INSTR_APP_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INSTR_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INST_APP.INSTR_APP_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INST_APP.INSTR_APP_PK Bound Attachments |
Name | Current Value |
INSTR.INSTR_PK |
TableName | INSTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR.INSTR_PK Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
INSTR.INSTR_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INSTR_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INSTR.INSTR_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR.INSTR_PK Bound Attachments |
Name | Current Value |
INSTR_CONFIG.INSTR_CONFIG_PK |
TableName | INSTR_CONFIG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_CONFIG.INSTR_CONFIG_PK Index Columns |
ColumnName | Sort Order |
CONFIG_ID | Ascending |
INSTR_CONFIG.INSTR_CONFIG_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INSTR_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INSTR_CONFIG.INSTR_CONFIG_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_CONFIG.INSTR_CONFIG_PK Bound Attachments |
Name | Current Value |
INSTR_CONFIG_APP.INSTR_CONFIG_APP_PK |
TableName | INSTR_CONFIG_APP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_CONFIG_APP.INSTR_CONFIG_APP_PK Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
CONFIG_ID | Ascending |
APP_ID | Ascending |
CREATE_DTE | Ascending |
INSTR_CONFIG_APP.INSTR_CONFIG_APP_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INSTR_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INSTR_CONFIG_APP.INSTR_CONFIG_APP_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_CONFIG_APP.INSTR_CONFIG_APP_PK Bound Attachments |
Name | Current Value |
INSTR_CONFIG_ASSC.INSTR_CONFIG_ASSC_PK |
TableName | INSTR_CONFIG_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_CONFIG_ASSC.INSTR_CONFIG_ASSC_PK Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
CONFIG_ID | Ascending |
CREATE_DTE | Ascending |
INSTR_CONFIG_ASSC.INSTR_CONFIG_ASSC_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INSTR_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INSTR_CONFIG_ASSC.INSTR_CONFIG_ASSC_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_CONFIG_ASSC.INSTR_CONFIG_ASSC_PK Bound Attachments |
Name | Current Value |
INSTR_CONFIG_URL.INSTR_CONFIG_URL_PK |
TableName | INSTR_CONFIG_URL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_CONFIG_URL.INSTR_CONFIG_URL_PK Index Columns |
ColumnName | Sort Order |
EQUIP_ID | Ascending |
CONFIG_ID | Ascending |
CREATE_DTE | Ascending |
URL | Ascending |
INSTR_CONFIG_URL.INSTR_CONFIG_URL_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INSTR_INDEX_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 64 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INSTR_CONFIG_URL.INSTR_CONFIG_URL_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_CONFIG_URL.INSTR_CONFIG_URL_PK Bound Attachments |
Name | Current Value |