ADDNL_REV.PK_ADDNL_REV |
TableName | ADDNL_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ADDNL_REV.PK_ADDNL_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FIRST_NM | Ascending |
LAST_NM | Ascending |
ADDNL_REV.PK_ADDNL_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 |
ADDNL_REV.PK_ADDNL_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ADDNL_REV.PK_ADDNL_REV 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 |
CONTENT_TYPE.PK_CONTENT_TYPE |
TableName | CONTENT_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CONTENT_TYPE.PK_CONTENT_TYPE Index Columns |
ColumnName | Sort Order |
CONTENT_ID | Ascending |
CONTENT_TYPE.PK_CONTENT_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 |
CONTENT_TYPE.PK_CONTENT_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CONTENT_TYPE.PK_CONTENT_TYPE Bound Attachments |
Name | Current Value |
CUPS_ACT.PK_CUPS_ACT |
TableName | CUPS_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CUPS_ACT.PK_CUPS_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
CUPS_ACT.PK_CUPS_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 |
CUPS_ACT.PK_CUPS_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CUPS_ACT.PK_CUPS_ACT Bound Attachments |
Name | Current Value |
CUPS_LOG.PK_CUPS_LOG |
TableName | CUPS_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CUPS_LOG.PK_CUPS_LOG Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
MOD_DTE | Ascending |
CUPS_LOG.PK_CUPS_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 |
CUPS_LOG.PK_CUPS_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CUPS_LOG.PK_CUPS_LOG Bound Attachments |
Name | Current Value |
DESC_RSCH.PK_DESC_RSCH |
TableName | DESC_RSCH |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DESC_RSCH.PK_DESC_RSCH Index Columns |
ColumnName | Sort Order |
DESC_RSCH_ID | Ascending |
DESC_RSCH.PK_DESC_RSCH 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 |
DESC_RSCH.PK_DESC_RSCH Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DESC_RSCH.PK_DESC_RSCH Bound Attachments |
Name | Current Value |
EMAIL_PREV.PK_EMAIL_PREV |
TableName | EMAIL_PREV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMAIL_PREV.PK_EMAIL_PREV Index Columns |
ColumnName | Sort Order |
TEMPLATE_ID | Ascending |
SEQ_ID | Ascending |
EMAIL_PREV.PK_EMAIL_PREV 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 |
EMAIL_PREV.PK_EMAIL_PREV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMAIL_PREV.PK_EMAIL_PREV Bound Attachments |
Name | Current Value |
EMAIL_SENT.PK_EMAIL_SENT |
TableName | EMAIL_SENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMAIL_SENT.PK_EMAIL_SENT Index Columns |
ColumnName | Sort Order |
TEMPLATE_ID | Ascending |
SEQ_ID | Ascending |
EMAIL_SENT.PK_EMAIL_SENT 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 |
EMAIL_SENT.PK_EMAIL_SENT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMAIL_SENT.PK_EMAIL_SENT Bound Attachments |
Name | Current Value |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE |
TableName | EMAIL_TEMPLATE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Index Columns |
ColumnName | Sort Order |
TEMPLATE_ID | Ascending |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE 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 |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Bound Attachments |
Name | Current Value |
EMAIL_TMPL_TAG.PK_TAG_SRC |
TableName | EMAIL_TMPL_TAG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMAIL_TMPL_TAG.PK_TAG_SRC Index Columns |
ColumnName | Sort Order |
TEMPLATE_ID | Ascending |
TAG_ID | Ascending |
EMAIL_TMPL_TAG.PK_TAG_SRC 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 |
EMAIL_TMPL_TAG.PK_TAG_SRC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMAIL_TMPL_TAG.PK_TAG_SRC 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 |
EXPT_CYCLE.PK_EXPT_CYCLE |
TableName | EXPT_CYCLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_CYCLE.PK_EXPT_CYCLE Index Columns |
ColumnName | Sort Order |
CY_ID | Ascending |
EXPT_CYCLE.PK_EXPT_CYCLE 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 |
EXPT_CYCLE.PK_EXPT_CYCLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_CYCLE.PK_EXPT_CYCLE Bound Attachments |
Name | Current Value |
FUND_SRC.PK_FUND_SRC |
TableName | FUND_SRC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FUND_SRC.PK_FUND_SRC Index Columns |
ColumnName | Sort Order |
FUND_ID | Ascending |
FUND_SRC.PK_FUND_SRC 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 |
FUND_SRC.PK_FUND_SRC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FUND_SRC.PK_FUND_SRC Bound Attachments |
Name | Current Value |
FUND_STAT.PK_FUND_STAT |
TableName | FUND_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FUND_STAT.PK_FUND_STAT Index Columns |
ColumnName | Sort Order |
FUND_STAT_ID | Ascending |
FUND_STAT.PK_FUND_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 |
FUND_STAT.PK_FUND_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FUND_STAT.PK_FUND_STAT Bound Attachments |
Name | Current Value |
GRP_CAPBLTY.PK_GRP_CAPBLTY |
TableName | GRP_CAPBLTY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
GRP_CAPBLTY.PK_GRP_CAPBLTY Index Columns |
ColumnName | Sort Order |
CAPBLTY_ID | Ascending |
GRP_CAPBLTY.PK_GRP_CAPBLTY 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 |
GRP_CAPBLTY.PK_GRP_CAPBLTY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
GRP_CAPBLTY.PK_GRP_CAPBLTY Bound Attachments |
Name | Current Value |
GRP_LEAD_RSCH_CAPBLTY_ASSC.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC |
TableName | GRP_LEAD_RSCH_CAPBLTY_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
GRP_LEAD_RSCH_CAPBLTY_ASSC.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
RSCH_CAP_ID | Ascending |
GRP_LEAD_RSCH_CAPBLTY_ASSC.PK_GRP_LEAD_RSCH_CAPBLTY_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 |
GRP_LEAD_RSCH_CAPBLTY_ASSC.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
GRP_LEAD_RSCH_CAPBLTY_ASSC.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC Bound Attachments |
Name | Current Value |
INST.PK_INST |
TableName | INST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INST.PK_INST Index Columns |
ColumnName | Sort Order |
INST_ID | Ascending |
INST.PK_INST 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 |
INST.PK_INST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INST.PK_INST 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 |
MBR_ROLE.PK_MBR_ROLE |
TableName | MBR_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MBR_ROLE.PK_MBR_ROLE Index Columns |
ColumnName | Sort Order |
MBR_ROLE_ID | Ascending |
MBR_ROLE.PK_MBR_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 |
MBR_ROLE.PK_MBR_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MBR_ROLE.PK_MBR_ROLE Bound Attachments |
Name | Current Value |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPRT_TEAM_MBR |
TableName | NONVAL_EXPT_TEAM_MBR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPRT_TEAM_MBR Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
EMAIL_ADDR | Ascending |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPRT_TEAM_MBR 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 |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPRT_TEAM_MBR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPRT_TEAM_MBR Bound Attachments |
Name | Current Value |
PERSON.PK_PERSON |
TableName | PERSON |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERSON.PK_PERSON Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PERSON.PK_PERSON 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 |
PERSON.PK_PERSON Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERSON.PK_PERSON Bound Attachments |
Name | Current Value |
PERSON.idx_username |
TableName | PERSON |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX XF_ADMIN.idx_username ON XF_ADMIN.PERSON(USRNM)      LOGGING ; |
PERSON.idx_username Index Columns |
ColumnName | Sort Order |
USRNM | Ascending |
PERSON.idx_username 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 |
PERSON.idx_username Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERSON.idx_username 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 |
PRPSL_ACT.PK_PRPSL_ACT |
TableName | PRPSL_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ACT.PK_PRPSL_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
PRPSL_ACT.PK_PRPSL_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 |
PRPSL_ACT.PK_PRPSL_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ACT.PK_PRPSL_ACT Bound Attachments |
Name | Current Value |
PRPSL_CAT.PK_PRPSL_CAT |
TableName | PRPSL_CAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_CAT.PK_PRPSL_CAT Index Columns |
ColumnName | Sort Order |
PRPSL_CAT_ID | Ascending |
PRPSL_CAT.PK_PRPSL_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 |
PRPSL_CAT.PK_PRPSL_CAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_CAT.PK_PRPSL_CAT Bound Attachments |
Name | Current Value |
PRPSL_DESC_RSCH_ASSC.PK_PRPSL_DESC_RSCH_ASSC |
TableName | PRPSL_DESC_RSCH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_DESC_RSCH_ASSC.PK_PRPSL_DESC_RSCH_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
DESC_RSCH_ID | Ascending |
PRPSL_DESC_RSCH_ASSC.PK_PRPSL_DESC_RSCH_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 |
PRPSL_DESC_RSCH_ASSC.PK_PRPSL_DESC_RSCH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_DESC_RSCH_ASSC.PK_PRPSL_DESC_RSCH_ASSC Bound Attachments |
Name | Current Value |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV |
TableName | PRPSL_FEAS_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_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 |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV Bound Attachments |
Name | Current Value |
PRPSL_FUND.PK_PRPSL_FUND |
TableName | PRPSL_FUND |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FUND.PK_PRPSL_FUND Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FUND_ID | Ascending |
PRPSL_FUND.PK_PRPSL_FUND 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 |
PRPSL_FUND.PK_PRPSL_FUND Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND.PK_PRPSL_FUND Bound Attachments |
Name | Current Value |
PRPSL_FUND_AGCY.PK_PRPSL_FUND_AGCY |
TableName | PRPSL_FUND_AGCY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FUND_AGCY.PK_PRPSL_FUND_AGCY Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FUND_STAT_ID | Ascending |
FUND_AGENCY | Ascending |
PRPSL_FUND_AGCY.PK_PRPSL_FUND_AGCY 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 |
PRPSL_FUND_AGCY.PK_PRPSL_FUND_AGCY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND_AGCY.PK_PRPSL_FUND_AGCY Bound Attachments |
Name | Current Value |
PRPSL_FUND_CNTRY.PK_PRPSL_FUND_CNTRY |
TableName | PRPSL_FUND_CNTRY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FUND_CNTRY.PK_PRPSL_FUND_CNTRY Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FUND_ID | Ascending |
CNTRY_ID | Ascending |
PRPSL_FUND_CNTRY.PK_PRPSL_FUND_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 |
PRPSL_FUND_CNTRY.PK_PRPSL_FUND_CNTRY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND_CNTRY.PK_PRPSL_FUND_CNTRY Bound Attachments |
Name | Current Value |
PRPSL_FUND_STAT.PK_PRPSL_FUND_STAT |
TableName | PRPSL_FUND_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FUND_STAT.PK_PRPSL_FUND_STAT Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FUND_STAT_ID | Ascending |
PRPSL_FUND_STAT.PK_PRPSL_FUND_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 |
PRPSL_FUND_STAT.PK_PRPSL_FUND_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND_STAT.PK_PRPSL_FUND_STAT Bound Attachments |
Name | Current Value |
PRPSL_INSTR_ASSC.PK_PRPSL_INSTR_ASSC |
TableName | PRPSL_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_INSTR_ASSC.PK_PRPSL_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
INSTR_ID | Ascending |
PRPSL_INSTR_ASSC.PK_PRPSL_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 |
PRPSL_INSTR_ASSC.PK_PRPSL_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR_ASSC.PK_PRPSL_INSTR_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LOG.PK_PRPSL_LOG |
TableName | PRPSL_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LOG.PK_PRPSL_LOG Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
ACT_ID | Ascending |
CUR_DTE | Ascending |
PRPSL_LOG.PK_PRPSL_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 |
PRPSL_LOG.PK_PRPSL_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LOG.PK_PRPSL_LOG Bound Attachments |
Name | Current Value |
PRPSL_PDF.PK_PRPSL_PDF |
TableName | PRPSL_PDF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_PDF.PK_PRPSL_PDF Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
CONTENT_ID | Ascending |
PRPSL_PDF.PK_PRPSL_PDF 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 |
PRPSL_PDF.PK_PRPSL_PDF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_PDF.PK_PRPSL_PDF Bound Attachments |
Name | Current Value |
PRPSL_REV_COMM.PK_PRPSL_REV_COMM |
TableName | PRPSL_REV_COMM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_REV_COMM.PK_PRPSL_REV_COMM Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_REV_COMM.PK_PRPSL_REV_COMM 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 |
PRPSL_REV_COMM.PK_PRPSL_REV_COMM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_REV_COMM.PK_PRPSL_REV_COMM Bound Attachments |
Name | Current Value |
PRPSL_ROLE.PK_PRPSL_ROLE |
TableName | PRPSL_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ROLE.PK_PRPSL_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
PRPSL_ROLE.PK_PRPSL_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 |
PRPSL_ROLE.PK_PRPSL_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ROLE.PK_PRPSL_ROLE Bound Attachments |
Name | Current Value |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC |
TableName | PRPSL_ROLE_PERS_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_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 |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC Bound Attachments |
Name | Current Value |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA |
TableName | PRPSL_RSCH_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
RSCH_AREA_ID | Ascending |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_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 |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA Bound Attachments |
Name | Current Value |
PRPSL_SCI_REV.PK_PRPSL_SCI_REV |
TableName | PRPSL_SCI_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SCI_REV.PK_PRPSL_SCI_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_SCI_REV.PK_PRPSL_SCI_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 |
PRPSL_SCI_REV.PK_PRPSL_SCI_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SCI_REV.PK_PRPSL_SCI_REV Bound Attachments |
Name | Current Value |
PRPSL_SMPL_HAZ_ASSC.PK_PRPSL_SMPL_HAZ_ASSC |
TableName | PRPSL_SMPL_HAZ_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SMPL_HAZ_ASSC.PK_PRPSL_SMPL_HAZ_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_SAFE_ID | Ascending |
PRPSL_SMPL_HAZ_ASSC.PK_PRPSL_SMPL_HAZ_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 |
PRPSL_SMPL_HAZ_ASSC.PK_PRPSL_SMPL_HAZ_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SMPL_HAZ_ASSC.PK_PRPSL_SMPL_HAZ_ASSC Bound Attachments |
Name | Current Value |
PRPSL_SMPL_TYPE_ASSC.PK_PRPSL_SMPL_TYPE_ASSC |
TableName | PRPSL_SMPL_TYPE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SMPL_TYPE_ASSC.PK_PRPSL_SMPL_TYPE_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_TYPE_ID | Ascending |
PRPSL_ID | Ascending |
PRPSL_SMPL_TYPE_ASSC.PK_PRPSL_SMPL_TYPE_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 |
PRPSL_SMPL_TYPE_ASSC.PK_PRPSL_SMPL_TYPE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SMPL_TYPE_ASSC.PK_PRPSL_SMPL_TYPE_ASSC Bound Attachments |
Name | Current Value |
PRPSL_STAFF_CONT.PK_PRPSL_STAFF_CONT |
TableName | PRPSL_STAFF_CONT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_STAFF_CONT.PK_PRPSL_STAFF_CONT Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_STAFF_CONT.PK_PRPSL_STAFF_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 |
PRPSL_STAFF_CONT.PK_PRPSL_STAFF_CONT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_STAFF_CONT.PK_PRPSL_STAFF_CONT Bound Attachments |
Name | Current Value |
PRPSL_STAT.PK_PRPSL_STAT |
TableName | PRPSL_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_STAT.PK_PRPSL_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
PRPSL_STAT.PK_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 |
PRPSL_STAT.PK_PRPSL_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_STAT.PK_PRPSL_STAT Bound Attachments |
Name | Current Value |
PRPSL_SUGG_REV.PK_PRPSL_SUGG_REV |
TableName | PRPSL_SUGG_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SUGG_REV.PK_PRPSL_SUGG_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_SUGG_REV.PK_PRPSL_SUGG_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 |
PRPSL_SUGG_REV.PK_PRPSL_SUGG_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SUGG_REV.PK_PRPSL_SUGG_REV Bound Attachments |
Name | Current Value |
PRPSL_TECH_CONT.PK_PRPSL_TECH_CONT |
TableName | PRPSL_TECH_CONT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TECH_CONT.PK_PRPSL_TECH_CONT Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_TECH_CONT.PK_PRPSL_TECH_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 |
PRPSL_TECH_CONT.PK_PRPSL_TECH_CONT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TECH_CONT.PK_PRPSL_TECH_CONT Bound Attachments |
Name | Current Value |
RSCH_AREA.PK_RSCH_AREA |
TableName | RSCH_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSCH_AREA.PK_RSCH_AREA Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
RSCH_AREA.PK_RSCH_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 |
RSCH_AREA.PK_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSCH_AREA.PK_RSCH_AREA Bound Attachments |
Name | Current Value |
RSCH_CAPBLTY.PK_RSCH_CAPBLTY |
TableName | RSCH_CAPBLTY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSCH_CAPBLTY.PK_RSCH_CAPBLTY Index Columns |
ColumnName | Sort Order |
RSCH_CAP_ID | Ascending |
RSCH_CAPBLTY.PK_RSCH_CAPBLTY 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 |
RSCH_CAPBLTY.PK_RSCH_CAPBLTY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSCH_CAPBLTY.PK_RSCH_CAPBLTY Bound Attachments |
Name | Current Value |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT |
TableName | SCI_REVIEW_MERIT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT Index Columns |
ColumnName | Sort Order |
RATING_ID | Ascending |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT 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 |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT Bound Attachments |
Name | Current Value |
SMPL_SAFE.PK_SMPL_SAFE |
TableName | SMPL_SAFE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SMPL_SAFE.PK_SMPL_SAFE Index Columns |
ColumnName | Sort Order |
SMPL_SAFE_ID | Ascending |
SMPL_SAFE.PK_SMPL_SAFE 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_SAFE.PK_SMPL_SAFE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SMPL_SAFE.PK_SMPL_SAFE Bound Attachments |
Name | Current Value |
SMPL_TYPE.PK_SMPL_TYPE |
TableName | SMPL_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SMPL_TYPE.PK_SMPL_TYPE Index Columns |
ColumnName | Sort Order |
SMPL_TYPE_ID | Ascending |
SMPL_TYPE.PK_SMPL_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 |
SMPL_TYPE.PK_SMPL_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SMPL_TYPE.PK_SMPL_TYPE Bound Attachments |
Name | Current Value |
USER_ACESS_MODE.PK_USER_ACESS_MODE |
TableName | USER_ACESS_MODE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_ACESS_MODE.PK_USER_ACESS_MODE Index Columns |
ColumnName | Sort Order |
USER_ACCESS_ID | Ascending |
USER_ACESS_MODE.PK_USER_ACESS_MODE 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_ACESS_MODE.PK_USER_ACESS_MODE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_ACESS_MODE.PK_USER_ACESS_MODE Bound Attachments |
Name | Current Value |
VAL_EXPT_TEAM_MBR.PK_EXPT_TEAM_MBR |
TableName | VAL_EXPT_TEAM_MBR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
VAL_EXPT_TEAM_MBR.PK_EXPT_TEAM_MBR Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
VAL_EXPT_TEAM_MBR.PK_EXPT_TEAM_MBR 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 |
VAL_EXPT_TEAM_MBR.PK_EXPT_TEAM_MBR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
VAL_EXPT_TEAM_MBR.PK_EXPT_TEAM_MBR Bound Attachments |
Name | Current Value |