Customize DDL tab
Restriction: This topic applies to Windows environments only.
- Objects grid
- Lists the schema objects available in the transfer list specified in the
Associated Transfer List field on the
DDL Tasks tab, in the sequence in which they appear on the transfer list.
- Check All
- Checks all schema objects listed on the
Objects grid against a SQL Server data source and takes you to the
Results tab to view the results of the check. To use this option, you must have a test SQL Server data source specified in the
Data source to use for testing DDL field of your HCOSS Options.
- Revert All
- Removes all changes to SQL code made for all objects on the
Objects grid, setting the code back to its last saved state. Once saved, you cannot revert your changes.
- Save All
- Saves all changes to SQL code made for all objects on the
Objects grid. Once saved, you cannot revert your changes.
- Generated DDL
- Shows the DDL generated by default for the object selected on the
Objects grid.
- Customized DDL
- Edit the default DDL code for the object selected on the
Objects grid to customize the code generated into the DDL.
- Revert
- Removes all changes made to the SQL code in the
Customized DDL field, setting the code back to its default state. Once saved, you cannot revert your changes.