Indicate default naming conventions when saving DDL to a SQL file, and whether to save objects of the same type in one file, or to save all objects into individual files.
| Option | Description |
|---|---|
| Specify the File Name for DDL Generator Output | Use variables to indicate the default file naming conventions. The default is {objectType}{profile}{database}{objectName}, for example, Procedure_ASE15_demo_sp2_ddl.sql. Add or delete variables to create the desired default file naming convention. |
| Specify the Folder Hierarchy for DDL Generator Output | Use constants and variables to indicate where in the project folder hierarchy to save the SQL file. The default is Database\Schema\{owner}\{objectType}. For example, if you generate DDL for an index, the folder hierarchy might look like MyProject\Database\Schema\dbo\Index\<filename>.sql
. Add or delete subfolders or variables to create the desired default location. |
| Option | Description | |
|---|---|---|
| Prefix | (Optional) Indicate a file prefix. | |
| Suffix | (Optional) Indicate a numeric file suffix. | |
| One File for Every Object | Generate one file for every object using the schema and object name. | |
| Group by Object Type | Use the object type name as the file name. | |
| Add Database Name as Prefix | Use the database name as a prefix to the file name. | |
| Create Folder for Each Type | Generate a folder for all objects of the same type. | |