Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Set Table Owner/Schema
Some relational databases enable you to assign a table to one of several schemas (or owners) within the same database. Enterprise Architect enables you to model this information using the Owner Tagged Value. By setting this optional value, you can tailor the generated DDL script, causing the table name to be prefixed by its assigned owner name.
How To:
Step |
Action |
See Also |
---|---|---|
1 |
Add a Tagged Value named Owner, to the Table element |
|
2 |
Type the owner name for this table in the Value field of the Tagged Value Changes are automatically saved |
|
Notes:
- For a PostgreSQL database, 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-2011 Sparx Systems Pty Ltd.