The Xml Output element describes the structure of the resulting SQL file.
Initially, the output contains the Database. To a Database, one or multiple Schemas can be added by right-clicking on the Database.
A Schema can have assigned one or more Tables, which can contain multiple Rows and RowSequences.
Note:
• | The Database is the only element that cannot be removed from a Data Architect diagram. |
Terminology
In Data Architect terminology, the Database Output can contain schemas, tables, row sequences and rows. For example, in the diagram above there are:
- one Database
- one Schema (Schema:dbo)
- one Table
- one Row Sequence (RowSequence)