PART.PK_PART |
TableName | PART |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PART.PK_PART Index Columns |
ColumnName | Sort Order |
PART_ID | Ascending |
PART.PK_PART Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART.PK_PART Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART.PK_PART Bound Attachments |
Name | Current Value |
PART_CAB.PK_PART_CAB |
TableName | PART_CAB |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PART_CAB.PK_PART_CAB Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
PART_CAB.PK_PART_CAB Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB.PK_PART_CAB Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB.PK_PART_CAB Bound Attachments |
Name | Current Value |
PART_CAB_DR.PK_PART_CAB_DR |
TableName | PART_CAB_DR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PART_CAB_DR.PK_PART_CAB_DR Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
DR_ID | Ascending |
PART_CAB_DR.PK_PART_CAB_DR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR.PK_PART_CAB_DR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR.PK_PART_CAB_DR Bound Attachments |
Name | Current Value |
PART_CAB_DR.FK_PCD_PART_CAB |
TableName | PART_CAB_DR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EQUIP.FK_PCD_PART_CAB ON EQUIP.PART_CAB_DR(CAB_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PART_CAB_DR.FK_PCD_PART_CAB Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
PART_CAB_DR.FK_PCD_PART_CAB Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR.FK_PCD_PART_CAB Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR.FK_PCD_PART_CAB Bound Attachments |
Name | Current Value |
PART_CAB_DR.FK_PCD_PART |
TableName | PART_CAB_DR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EQUIP.FK_PCD_PART ON EQUIP.PART_CAB_DR(PART_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PART_CAB_DR.FK_PCD_PART Index Columns |
ColumnName | Sort Order |
PART_ID | Ascending |
PART_CAB_DR.FK_PCD_PART Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR.FK_PCD_PART Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR.FK_PCD_PART Bound Attachments |
Name | Current Value |
PART_CAB_DR_BIN.PK_PART_CAB_DR_BIN |
TableName | PART_CAB_DR_BIN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PART_CAB_DR_BIN.PK_PART_CAB_DR_BIN Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
DR_ID | Ascending |
BIN_ID | Ascending |
PART_CAB_DR_BIN.PK_PART_CAB_DR_BIN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR_BIN.PK_PART_CAB_DR_BIN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR_BIN.PK_PART_CAB_DR_BIN Bound Attachments |
Name | Current Value |
PART_CAB_DR_BIN.FK_PCDB_PART_CAB_DR |
TableName | PART_CAB_DR_BIN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EQUIP.FK_PCDB_PART_CAB_DR ON EQUIP.PART_CAB_DR_BIN(CAB_ID, DR_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PART_CAB_DR_BIN.FK_PCDB_PART_CAB_DR Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
DR_ID | Ascending |
PART_CAB_DR_BIN.FK_PCDB_PART_CAB_DR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR_BIN.FK_PCDB_PART_CAB_DR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR_BIN.FK_PCDB_PART_CAB_DR Bound Attachments |
Name | Current Value |
PART_CAB_DR_BIN.FK_PCDB_PART |
TableName | PART_CAB_DR_BIN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EQUIP.FK_PCDB_PART ON EQUIP.PART_CAB_DR_BIN(PART_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PART_CAB_DR_BIN.FK_PCDB_PART Index Columns |
ColumnName | Sort Order |
PART_ID | Ascending |
PART_CAB_DR_BIN.FK_PCDB_PART Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR_BIN.FK_PCDB_PART Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR_BIN.FK_PCDB_PART Bound Attachments |
Name | Current Value |
PART_CAB_DR_BIN_SEC.PK474 |
TableName | PART_CAB_DR_BIN_SEC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PART_CAB_DR_BIN_SEC.PK474 Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
DR_ID | Ascending |
BIN_ID | Ascending |
SEC_ID | Ascending |
PART_CAB_DR_BIN_SEC.PK474 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR_BIN_SEC.PK474 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR_BIN_SEC.PK474 Bound Attachments |
Name | Current Value |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART_CAB_DR_BIN |
TableName | PART_CAB_DR_BIN_SEC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EQUIP.FK_PCDBS_PART_CAB_DR_BIN ON EQUIP.PART_CAB_DR_BIN_SEC(CAB_ID, DR_ID, BIN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART_CAB_DR_BIN Index Columns |
ColumnName | Sort Order |
CAB_ID | Ascending |
DR_ID | Ascending |
BIN_ID | Ascending |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART_CAB_DR_BIN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART_CAB_DR_BIN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART_CAB_DR_BIN Bound Attachments |
Name | Current Value |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART |
TableName | PART_CAB_DR_BIN_SEC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX EQUIP.FK_PCDBS_PART ON EQUIP.PART_CAB_DR_BIN_SEC(PART_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE EQUIP_INDEX_TS      LOGGING      STORAGE(INITIAL 64K              NEXT 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART Index Columns |
ColumnName | Sort Order |
PART_ID | Ascending |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | EQUIP_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 |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PART_CAB_DR_BIN_SEC.FK_PCDBS_PART Bound Attachments |
Name | Current Value |