Generating Data Definition Language (DDL) files from XML schemas

You can generate a Data Definition Language (DDL) from an XML schema file. This DDL file can be used to generate database tables based on your XML schema file.

The following instructions were written for the Resource perspective, but they will also work in many other perspectives.

To generate a relational table definition from an XML schema, follow these steps:

  1. In the Navigator view, right-click the XML schema that you want to work with.
  2. From its pop-up menu click Generate > DDL.
  3. Select the project or folder that will contain the file. In the File name field, type the name of the file, for example MySchemaSQL.sql. The name of your file must end with the extension .sql. Click Finish.
The file appears in the Navigator view. To open it in the SQL editor, double-click it. You can now modify it as necessary.
Related concepts
Generating files from XML schemas
Related tasks
Creating XML schemas
Generating XML schema files from relational tables

Feedback