Extract DDL | Table/View Specific
Table/View specific
|
|
Note: Preferences preceded by an asterisk (*) are applicable to team coding operations when the Team Coding preference (see Use Extract DDL Preferences) is checked. |
| Option | Description | ||||
|---|---|---|---|---|---|
|
Include "Constraints" |
* Includes any constraints for the object in the DDL.
| ||||
| Include "Triggers" | *Includes any triggers for the object in the DDL. | ||||
| Include "Indexes" | Includes any indexes for the object in the DDL. | ||||
| Include "Comments" | *Includes any comments for the object in the DDL. | ||||
| Include "Primary Key in Table Definition" | Includes the Primary Key for the table in the DDL. | ||||
| Include "Synonyms" | Includes any Synonyms for the object in the DDL. | ||||
| Exclude Table column default values* | *Excludes all default values for the object from the DDL. | ||||
| Include ENCRYPTION clause | Includes any encryption-related clauses (such as encryption algorithm to be used, salting and so forth) for the object in the DDL. | ||||
| Include FORCE clause | Select the measurement unit you want to use for specifying margin width and other print settings. | ||||
| Include datatype definition for table column | Include datatype definition for any columns that are of complex type. | ||||
| Include Byte/Char for Table Columns | Display Byte or Char as length for a column. |
Partitioning
| Option | Description | ||||
|---|---|---|---|---|---|
| Include "Storage Clause" for Partitions | Includes any Partition settings from the Storage Clause for the object in the DDL. | ||||
| Include "Storage Clause" for Index Partitions | Includes any Index Partition settings from the Storage Clause for the object in the DDL. | ||||
| Storage Clause Options | Include storage clauses with either non-default values or all values in the DDL. | ||||
| Include "Tablespace Name" for Partitions | Includes the Tablespace names any Partition for the object in the DDL. | ||||
| Include "Tablespace Name" for Index Partitions | Includes the Tablespace names in any Indexed Partition for the object in the DDL. | ||||
|
Exclude Partition List for Local Index |
Excludes Local Index Partitions for the object in the DDL.
| ||||
|
List Individual Hash Partitions |
|