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:
- In the Navigator view, right-click the XML schema that you want
to work with.
- From its pop-up menu click Generate > DDL.
- 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.