Generate a DDL file

Applies to User roles: System Administrator

Database administrators often rely on conceptual and physical data models to understand the relationships among tables, records, and data, and to produce reports. If you have administrative rights, you can customize the files and links used to create the component Database Definition Language (DDL) statements.

To generate DDL statements in a file using the Entity Relationship Diagram (ERD) Creation utility:

  1. Click Tailoring > Tailoring Tools > ERD Create Records.
  2. Determine the correct export mode for the DDL statements.
    • Full mode: Creates one foreign key definition for each unique field or file relationship. You can have multiple links between two files.
    • Simple mode: Creates one foreign key definition for each file-to-file relationship within each relationship type.
  3. From the ERD Creator Definition form, click the More Actions menu.
  4. Select one of the following:
    • Create/Export DDL > Full.
    • Create/Export DDL > Simple.

The output of the ERD Create utility automatically resides at the root level of the Service Manager client installation folder. The file name is the DDL file name with a .sql file extension.

Example: ..\Program Files(x86)\Micro Focus\ Service Manager x.xx\ Client\ddl_name.sql.

Related concepts

DDL mode
Entity Relationship Diagram creation utility
What are Master link records?
What are related link records?
What is the required input for ERD Create?

Related references

Checklist: Creating an ERD record for an application
Checklist: Generating a DDL file

Related tasks

Associate a data policy record with an application
Create an ERD record
Create manual relationships
Modify an ERD record
Import a DDL file into a database modeling tool