DDML, a language based on XML (Extensible Markup Language), allows you to logically define the entities you want to add to the Precise schema, such as tables, views, indexes, foreign keys, and all other required components. It covers the common entities available in most popular DBMSs.
After you have defined all database entities in DDML, you must run the DDML creation script to physically create the entities in the database.
General DDML document format
The general format of a DDML document looks as follows:
Tag | Description |
---|---|
<tables-definition> | Root element of a DDML document. Its children are the main database entities:
|
<table-definition> | Includes the table-level attributes. Its children are the If a table is a statistics table, meaning means that the type attribute has the value STATISTICS, the |
<ddl-definition> | Includes ddl-level attributes. |
<view-definition> | Includes view-level attributes. |
<tables-definition> tag
Root element of the DDML document.
Attribute | Definition |
---|---|
product | Required. Holds the product short name (product shortcut) consisting if two characters that define the product. In this case, three custom-defined products are available:
|