http://www.sqlpower.ca/forum/posts/list/2.page JForum - http://www.jforum.net
However, when I tried the forward engineering, only the physical names were used. Thus, when I run this sql script in the i Navigator all the table names and table attribute names (both long name and short names) are the physical names specified in PA.

Is there any way that I can tweak the PA to generate the sql script to use the logical name as the long name and also include the physical name as the short name via record format?

I could edit the sql generated to meet my goal, but I have around 20 tables with numerous attributes, I find it would be a big hassle to do it manually. In addition, me and my supervisors need to modify the schema after meeting with clients, it would be hard to keep the sql and schema consistent if there is no automatic way to include both the logical name and physical name.

Any help is appreciated. Thank you! ]]> http://www.sqlpower.ca/forum/posts/preList/2607/5855.page http://www.sqlpower.ca/forum/posts/preList/2607/5855.page GMT http://www.sqlpower.ca/forum/posts/preList/2607/5862.page http://www.sqlpower.ca/forum/posts/preList/2607/5862.page GMT
sorry, as far as I know there is no such option yet. As a premium support user you could file an enhancement request.

Benjamin]]> http://www.sqlpower.ca/forum/posts/preList/2607/5865.page http://www.sqlpower.ca/forum/posts/preList/2607/5865.page GMT http://www.sqlpower.ca/forum/posts/preList/2607/5867.page http://www.sqlpower.ca/forum/posts/preList/2607/5867.page GMT