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 |
PROC_BODY.PK_PROC_BODY |
TableName | PROC_BODY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROC_BODY.PK_PROC_BODY Index Columns |
ColumnName | Sort Order |
PROC_ID | Ascending |
REV_ID | Ascending |
SECTION_ID | Ascending |
PROC_BODY.PK_PROC_BODY 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 |
PROC_BODY.PK_PROC_BODY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROC_BODY.PK_PROC_BODY Bound Attachments |
Name | Current Value |
PROC_INSTR_ASSC.PK_PROC_INSTR_ASSC |
TableName | PROC_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROC_INSTR_ASSC.PK_PROC_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
PROC_ID | Ascending |
INSTR_ID | Ascending |
PROC_INSTR_ASSC.PK_PROC_INSTR_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 |
PROC_INSTR_ASSC.PK_PROC_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROC_INSTR_ASSC.PK_PROC_INSTR_ASSC Bound Attachments |
Name | Current Value |
PROC_PARA.PK_PROC_PARA |
TableName | PROC_PARA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROC_PARA.PK_PROC_PARA Index Columns |
ColumnName | Sort Order |
PROC_ID | Ascending |
REV_ID | Ascending |
SECTION_ID | Ascending |
PARA_ID | Ascending |
PROC_PARA.PK_PROC_PARA 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 |
PROC_PARA.PK_PROC_PARA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROC_PARA.PK_PROC_PARA Bound Attachments |
Name | Current Value |
PROC_REV.PK_PROC_REV |
TableName | PROC_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROC_REV.PK_PROC_REV Index Columns |
ColumnName | Sort Order |
PROC_ID | Ascending |
REV_ID | Ascending |
PROC_REV.PK_PROC_REV 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 |
PROC_REV.PK_PROC_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROC_REV.PK_PROC_REV Bound Attachments |
Name | Current Value |
PROCEDURE.PK_PROCEDURE |
TableName | PROCEDURE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROCEDURE.PK_PROCEDURE Index Columns |
ColumnName | Sort Order |
PROC_ID | Ascending |
PROCEDURE.PK_PROCEDURE 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 |
PROCEDURE.PK_PROCEDURE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROCEDURE.PK_PROCEDURE Bound Attachments |
Name | Current Value |
SECT.PK_SECT |
TableName | SECT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SECT.PK_SECT Index Columns |
ColumnName | Sort Order |
SECTION_ID | Ascending |
SECT.PK_SECT 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 |
SECT.PK_SECT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SECT.PK_SECT Bound Attachments |
Name | Current Value |
STAT.PK_STAT |
TableName | STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
STAT.PK_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
STAT.PK_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 |
STAT.PK_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STAT.PK_STAT Bound Attachments |
Name | Current Value |