Logical to Physical conversion and id column name

Toad Data Modeler
1

Hi,

I am new to TOAD although a data modeler and db architect and programmer for years.

I have found it is very good practice to use the exact same name for an attribute wherever that attribute may occur (both logical and physical models). However in my first test of converting logical data model to sql server physical model, TDM names the generated id columns with the same name regardless of entity name: “id”.

Is there a way to have TDM name the id columns when converting from logical to physical so that an “id” column name will include the entity name, and that exact name will be used for all generated instances of the attribute?

thanks,

kenzo

2

Hi,

I agree it is a good practice to name attributes uniquely, but I feel you have multiple “id” columns in your logical model and expect them to be converted to “TableName”+“id” in physical model. I guess you have two possibilities:

  1. Add table prefix to names in logical model

  2. Download and install the Rename FK Column macro and execute this macro on your model after coversion from Logical. Explanation:

http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2013/12/20/how-to-add-parent-table-name-to-fk-columns-at-once.aspx

Regards,

Vaclav

3

thank you Vaclav!

ken

On Fri, Dec 20, 2013 at 4:03 AM, Vaclav Frolik bounce-Vaclav_Frolik@toadworld.com wrote:

RE: Logical to Physical conversion and id column name

Reply by Vaclav Frolik
Hi,

I agree it is a good practice to name attributes uniquely, but I feel you have multiple "id" columns in your logical model and expect them to be converted to "TableName"+"id" in physical model. I guess you have two possibilities:

  1. Add table prefix to names in logical model
  1. Download and install the Rename FK Column macro and execute this macro on your model after coversion from Logical. Explanation:

http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2013/12/20/how-to-add-parent-table-name-to-fk-columns-at-once.aspx

Regards,

Vaclav

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Data Modeler - General notifications altogether.

Toad Data Modeler - Discussion Forum

Flag this post as spam/abuse.

--
"When it comes to database programming, the difference between theory and practice is much greater in theory than it is in practice."