CMPNT.PK_CMPNT |
TableName | CMPNT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CMPNT.PK_CMPNT Index Columns |
ColumnName | Sort Order |
PART_ID | Ascending |
CMPNT.PK_CMPNT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
CMPNT.PK_CMPNT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CMPNT.PK_CMPNT Bound Attachments |
Name | Current Value |
CMPNT_MATL.PK_CMPNT_MATL |
TableName | CMPNT_MATL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CMPNT_MATL.PK_CMPNT_MATL Index Columns |
ColumnName | Sort Order |
MATL_ID | Ascending |
CMPNT_MATL.PK_CMPNT_MATL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
CMPNT_MATL.PK_CMPNT_MATL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CMPNT_MATL.PK_CMPNT_MATL Bound Attachments |
Name | Current Value |
CMPNT_STAT.PK_CMPNT_STAT |
TableName | CMPNT_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CMPNT_STAT.PK_CMPNT_STAT Index Columns |
ColumnName | Sort Order |
CMPNT_STAT_ID | Ascending |
CMPNT_STAT.PK_CMPNT_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
CMPNT_STAT.PK_CMPNT_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CMPNT_STAT.PK_CMPNT_STAT Bound Attachments |
Name | Current Value |
CMPNT_TYPE.PK_CMPNT_TYPE |
TableName | CMPNT_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CMPNT_TYPE.PK_CMPNT_TYPE Index Columns |
ColumnName | Sort Order |
CMPNT_TYPE_ID | Ascending |
CMPNT_TYPE.PK_CMPNT_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
CMPNT_TYPE.PK_CMPNT_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CMPNT_TYPE.PK_CMPNT_TYPE Bound Attachments |
Name | Current Value |
DISTR.PK_DISTR |
TableName | DISTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DISTR.PK_DISTR Index Columns |
ColumnName | Sort Order |
DISTR_ID | Ascending |
DISTR.PK_DISTR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
DISTR.PK_DISTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DISTR.PK_DISTR Bound Attachments |
Name | Current Value |
DISTR_STAT.PK_DISTR_STAT |
TableName | DISTR_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DISTR_STAT.PK_DISTR_STAT Index Columns |
ColumnName | Sort Order |
DISTR_STAT_ID | Ascending |
DISTR_STAT.PK_DISTR_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
DISTR_STAT.PK_DISTR_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DISTR_STAT.PK_DISTR_STAT Bound Attachments |
Name | Current Value |
DISTR_TYPE.PK_DISTR_TYPE |
TableName | DISTR_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DISTR_TYPE.PK_DISTR_TYPE Index Columns |
ColumnName | Sort Order |
DISTR_TYPE_ID | Ascending |
DISTR_TYPE.PK_DISTR_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
DISTR_TYPE.PK_DISTR_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DISTR_TYPE.PK_DISTR_TYPE Bound Attachments |
Name | Current Value |
MATL_STAT.PK_MATL_STAT |
TableName | MATL_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MATL_STAT.PK_MATL_STAT Index Columns |
ColumnName | Sort Order |
MATL_STAT_ID | Ascending |
MATL_STAT.PK_MATL_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_STAT.PK_MATL_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MATL_STAT.PK_MATL_STAT Bound Attachments |
Name | Current Value |
MATL_TYPE.PK_MATL_TYPE |
TableName | MATL_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MATL_TYPE.PK_MATL_TYPE Index Columns |
ColumnName | Sort Order |
MATL_TYPE_ID | Ascending |
MATL_TYPE.PK_MATL_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_TYPE.PK_MATL_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MATL_TYPE.PK_MATL_TYPE Bound Attachments |
Name | Current Value |
MNFCTR.PK_MNFCTR |
TableName | MNFCTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MNFCTR.PK_MNFCTR Index Columns |
ColumnName | Sort Order |
MNFCTR_ID | Ascending |
MNFCTR.PK_MNFCTR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
MNFCTR.PK_MNFCTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MNFCTR.PK_MNFCTR Bound Attachments |
Name | Current Value |
MNFCTR_DISTR_ASSC.PK_MNFCTR_DISTR_ASSC |
TableName | MNFCTR_DISTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MNFCTR_DISTR_ASSC.PK_MNFCTR_DISTR_ASSC Index Columns |
ColumnName | Sort Order |
MNFCTR_ID | Ascending |
DISTR_ID | Ascending |
MNFCTR_DISTR_ASSC.PK_MNFCTR_DISTR_ASSC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
MNFCTR_DISTR_ASSC.PK_MNFCTR_DISTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MNFCTR_DISTR_ASSC.PK_MNFCTR_DISTR_ASSC Bound Attachments |
Name | Current Value |
MNFCTR_STAT.PK_MNFCTR_STAT |
TableName | MNFCTR_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MNFCTR_STAT.PK_MNFCTR_STAT Index Columns |
ColumnName | Sort Order |
MNFCTR_STAT_ID | Ascending |
MNFCTR_STAT.PK_MNFCTR_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
MNFCTR_STAT.PK_MNFCTR_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MNFCTR_STAT.PK_MNFCTR_STAT Bound Attachments |
Name | Current Value |
MNFCTR_TYPE.PK_MNFCTR_TYPE |
TableName | MNFCTR_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MNFCTR_TYPE.PK_MNFCTR_TYPE Index Columns |
ColumnName | Sort Order |
MNFCTR_TYPE_ID | Ascending |
MNFCTR_TYPE.PK_MNFCTR_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
MNFCTR_TYPE.PK_MNFCTR_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MNFCTR_TYPE.PK_MNFCTR_TYPE Bound Attachments |
Name | Current Value |