Reference table/class name in alias for DDL

[dj-obi]

Hi,

we just introduced Enterprise Architect 10 as our new database design tool and I do have a question regarding the alias field available for tables/classes.

I’m planning to use the alias to add the database and schema name for the DDL generation.

Is it possible to reference the table/class name dynamically, so I don’t have to copy the value from the “Name” field.

Otherwise, the alias may not get updated when the table name changes.

I’m looking for a placeholder that represents the table/class name which is automatically updated during the DDL-generation.


For example I would expect the DDL-generator to use the following information:

Name: MyTable
Alias: MyDatabase.MySchema.<Name>

in order to generate this script:
…
CREATE TABLE MyDatabase.MySchema.MyTable
…


Does such a placeholder exist?

If yes, how is it called?


Your support is much appreciated!

Thanks & Regards,

Mike

[Dermot]

Try the help page:
http://www.sparxsystems.com/enterprise_architect_user_guide/10/database_engineering/settableowner.html

there is a more general whitepaper on data modeling on:
http://community.sparxsystems.com/white-papers/669-data-modeling-from-conceptual-model-to-dbms

[dj-obi]

Hi,

Thanks a lot for your reply!

Unfortunately, tagged values or owner are not really the solution I'm looking for.
Apart from the additional hassle to maintain this information, I don't see a knock on effect on my DDL.

Maybe my example was misleading!

I don't want to hardcode the database and schema names in my tables/DDL. I'm using placeholders in the alias which are exported into the DDL and then get filled by my database installation.

For example:

$(dbname).$(dbschema).<TABLE-NAME>

Now I'm looking for a way to reference the table name from the "Name" property (represented in my example by <TABLE-NAME>).

This way I could use the same alias string for all tables/classes and I don't have to worry about maintaining it.

Your support is much appreciated!

Thanks & Regards,

Mike