Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Set Database Table Owner/Schema
For some relational databases you can assign a Database Table to one of several schemas (or owners) within the same database. By setting this optional value, you tailor the generated DDL script, causing the Table name to be prefixed by its assigned owner name. In Enterprise Architect you can model this information on the Table Details tab.
Access Table element | Element | Properties > General > Table Detail
Set the Database Table owner
Step |
Action |
See also |
|---|---|---|
1 |
In the Owner field, type the name of the owner or schema of the Table.
|
|
Notes
| · | For a PostgreSQL database, the Owner field defaults to public; you should instead create a Tagged Value named OWNER TO with the corresponding value |
Learn more
The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2015 Sparx Systems Pty Ltd.
