Generating the Oracle Annotated Schema File

You generate the annotated schema file by selecting it as an additional target for standard schema generation.

1. Select Language > Générate schema File to open the Generation dialog box.
2. Specify the directory in which to generate the file and select the XML in Database target on the Targets tab.
   
   
3. Click OK to begin the generation.

   The Result dialog box is displayed with the path of the annotated schema file selected.

4. Click Edit to open the generated annotated schema in your associated editor:
   
   

   Note the Oracle namespace (with the sql prefix) and annotations for tables (sql:SQLName) and ADTs (sql:SQLType)