ARRAY_VAL.PK_ARRAY_VAL |
TableName | ARRAY_VAL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ARRAY_VAL.PK_ARRAY_VAL Index Columns |
ColumnName | Sort Order |
SMPL_TIME | Ascending |
SEQ_NBR | Ascending |
CHANNEL_ID | Ascending |
ARRAY_VAL.PK_ARRAY_VAL 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 |
ARRAY_VAL.PK_ARRAY_VAL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ARRAY_VAL.PK_ARRAY_VAL Bound Attachments |
Name | Current Value |
CHAN_GRP.PK_CHAN_GRP |
TableName | CHAN_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHAN_GRP.PK_CHAN_GRP Index Columns |
ColumnName | Sort Order |
GRP_ID | Ascending |
CHAN_GRP.PK_CHAN_GRP 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 |
CHAN_GRP.PK_CHAN_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHAN_GRP.PK_CHAN_GRP Bound Attachments |
Name | Current Value |
CHANNEL.PK_CHANNEL |
TableName | CHANNEL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHANNEL.PK_CHANNEL Index Columns |
ColumnName | Sort Order |
CHANNEL_ID | Ascending |
CHANNEL.PK_CHANNEL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | chan_arch_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 |
CHANNEL.PK_CHANNEL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHANNEL.PK_CHANNEL Bound Attachments |
Name | Current Value |
ENUM_METADATA.PK_ENUM_DEF |
TableName | ENUM_METADATA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ENUM_METADATA.PK_ENUM_DEF Index Columns |
ColumnName | Sort Order |
CHANNEL_ID | Ascending |
ENUM_NBR | Ascending |
ENUM_METADATA.PK_ENUM_DEF 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 |
ENUM_METADATA.PK_ENUM_DEF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ENUM_METADATA.PK_ENUM_DEF Bound Attachments |
Name | Current Value |
NUM_METADATA.PK_NUM_FLD_DATA |
TableName | NUM_METADATA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NUM_METADATA.PK_NUM_FLD_DATA Index Columns |
ColumnName | Sort Order |
CHANNEL_ID | Ascending |
NUM_METADATA.PK_NUM_FLD_DATA 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 |
NUM_METADATA.PK_NUM_FLD_DATA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NUM_METADATA.PK_NUM_FLD_DATA Bound Attachments |
Name | Current Value |
RETENT.PK_RETENT |
TableName | RETENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RETENT.PK_RETENT Index Columns |
ColumnName | Sort Order |
RETENT_ID | Ascending |
RETENT.PK_RETENT 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 |
RETENT.PK_RETENT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RETENT.PK_RETENT Bound Attachments |
Name | Current Value |
SAMPLE.PK_SAMPLE |
TableName | SAMPLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE.PK_SAMPLE Index Columns |
ColumnName | Sort Order |
CHANNEL_ID | Ascending |
SMPL_TIME | Ascending |
SAMPLE.PK_SAMPLE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | chan_arch_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 |
SAMPLE.PK_SAMPLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE.PK_SAMPLE Bound Attachments |
Name | Current Value |
SEVERITY.PK_SEVERITY |
TableName | SEVERITY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SEVERITY.PK_SEVERITY Index Columns |
ColumnName | Sort Order |
SEVERITY_ID | Ascending |
SEVERITY.PK_SEVERITY Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | chan_arch_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 |
SEVERITY.PK_SEVERITY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SEVERITY.PK_SEVERITY Bound Attachments |
Name | Current Value |
SMPL_ENG.PK_SMPL_ENG |
TableName | SMPL_ENG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SMPL_ENG.PK_SMPL_ENG Index Columns |
ColumnName | Sort Order |
ENG_ID | Ascending |
SMPL_ENG.PK_SMPL_ENG 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_ENG.PK_SMPL_ENG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SMPL_ENG.PK_SMPL_ENG Bound Attachments |
Name | Current Value |
SMPL_MODE.PK_SMPL_MODE |
TableName | SMPL_MODE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SMPL_MODE.PK_SMPL_MODE Index Columns |
ColumnName | Sort Order |
SMPL_MODE_ID | Ascending |
SMPL_MODE.PK_SMPL_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 |
SMPL_MODE.PK_SMPL_MODE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SMPL_MODE.PK_SMPL_MODE Bound Attachments |
Name | Current Value |
STATUS.PK_STATUS |
TableName | STATUS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
STATUS.PK_STATUS Index Columns |
ColumnName | Sort Order |
STATUS_ID | Ascending |
STATUS.PK_STATUS Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | chan_arch_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 |
STATUS.PK_STATUS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STATUS.PK_STATUS Bound Attachments |
Name | Current Value |