Generating XML schema files from relational tables

You can generate an XML schema file from a relational table. You can use the XML schema to validate XML documents generated from the same relational table.

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

To generate a schema file from a relational table follow these steps:

  1. Open the Data view (Window > Show View > Other > Data > Data Definition).
  2. In the Data view, click the table that you want to work with.
  3. From its pop-up menu, click Generate XML Schema.
  4. Select a project or folder to contain the XML file and type a name for it. The name of the file must end in.xsd. Click Finish.
  5. The XML schema appears in the Navigator view.
Note: If you generate an XML schema from a database table containing full-width alphabet and digit names you will receive errors in the Problems view. Do not give database tables and columns names that contain DBCS characters.
Related tasks
Creating XML schemas
Generating XML schema files from XML files
Generating Java beans from an XML schema
Generating HTML documentation from an XML schema file
Related information
Editing XML schema properties
XML schema editor
Validating XML schemas
Generating XML schemas from DTD files

Feedback