PowerDesigner - foreign key column name

okay this is the issue

When you generate the PDM from the CDM, PowerDesigner generates, using
its own naming convention, the foreign key column that is placed in the
physical model table - we want to have control over this column name ie:
we want this foreign key column to be called f_key in our physical
table. Please note we are not talking about FK/PKconstraints names etc,
we are talking about the actual column name of the foreign key.
We have searched through the definition file and cannot find where its
being set.
Or is this not possible to control in PowerDesigner and you have to do
it the long way� ie: you have to generate the PDM from the CDM and then
manually go through each table in the PDM and rename the foreign key
column to what you want it called ?
�
�

0
xxxx
11/19/1999 10:08:11 PM
sybase.powerdesigner.general 9408 articles. 1 followers. Follow

1 Replies
1198 Views

Similar Articles

[PageSpeed] 18

No, you don't have control over the initial names of the FK columns when
generating a PDM.  The good news is, you only have to name them once.


--

Michael F. Nicewarner [TeamSybase]
mailto:mike.nicewarner@ibpinc.com
http://www.datamodel.org


xxxx <xxxx@xxx.com> wrote in message news:3835CA4A.8A4EF5B1@hotmail.com...
> okay this is the issue
>
> When you generate the PDM from the CDM, PowerDesigner generates, using
> its own naming convention, the foreign key column that is placed in the
> physical model table - we want to have control over this column name ie:
> we want this foreign key column to be called f_key in our physical
> table. Please note we are not talking about FK/PKconstraints names etc,
> we are talking about the actual column name of the foreign key.
> We have searched through the definition file and cannot find where its
> being set.
> Or is this not possible to control in PowerDesigner and you have to do
> it the long way ie: you have to generate the PDM from the CDM and then
> manually go through each table in the PDM and rename the foreign key
> column to what you want it called ?
>
>
>


0
Michael
11/22/1999 3:24:11 PM
Reply:

Similar Artilces:

Powerdesigner VBScript (get column name)
I would like to rename/reform the following names in PD: Physical model Alternative Name: >>AK_{table_name}_{table_column_name} -AK_Account_AccountNumber Relationship Name: >>FK_{table_name}_{reference_table_name}_{reference_column_name} -FK_Account_AccountPhone_HomePhoneID How do I get the "table_column_name" and "reference_column_name"? This is a multi-part message in MIME format. ---=_forums-1-dub4a07d5bb Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit VBScript attached. ---=_forums-1-dub4a0...

Please Help me: BUG in Powerdesigner: columns names are truncated
SQL Query Limitation at 512 chars? Hi, When i create a view with Powerdesigner 8.0.0.203, I put in SQL Query tab a long query with more than 512 chars. When i click on column tab, some columns names are truncated. Thanx Patrick Example select a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a1234657890, a123465789...

PowerDesign
Hi, Today is February 7, 2000. I am tryng to download trial version. I got registered, but hyperlink to an actual download is not working. Can you help me at some point. Thanks, Konstantin Konstantin, I just went to the Sybase web site and downloaded the trial version. There must have been a temporary problem when you tried. http://www.sybase.com/products/powerdesigner/trial/ click "download now" Regards, John Olson Team Sybase Konstantin wrote in message ... >Hi, >Today is February 7, 2000. I am tryng to download trial version. >I got registe...

How to migrate from PowerDesigner 6 to PowerDesigner 10
I have several PD 6 models I wish to migrate to version 10 and have a few questions: 1) It appears that opening the model with the new version will automatically convert it, but are there any issues I should be aware of first? Is there a conversion program for changing from such an old version? 2) How do I migrate the Process Models? It appears I can open them but it appears the porcess flow charts are gone! 3) Are there any other pitfalls of which I should beware? Cool, even V12 can open V6 models. The ProcessAnalyst model probably won't open cleanly. Man, I haven&...

How to migrate PowerDesigner 6 to PowerDesigner 11
I am with difficulties "to take" models generated in PowerDesigner 6 for PowerDesigner 11 (evaluation). Already I tried to make the steps below, but I did not get success. Step 1 - The basic File/Open I chose diagrama.pdm file (generated in version 6) and To open. It starts to read the archive and finishing he almost gives to the error "failed you read the file". Valley to detach that the procedure was attemped with other archives (also generated in version 6) and I did not get success and that the same ones continue functioning in version 6. Step 2 - Co...

How to use a full column name (table name and column name) with a DataReader
Hi, I have a problem retrieving the data with a DataReader from a stored proc that performs a join of two table with the same column's names but different data. Let me explain with an example: I have two tables: Table1: Id, Name Table2: Id, Name, IdTable1 The sproc is something like this: CREATE PROCEDURE [dbo].[SearchByName] (@Name nvarchar(40)) AS BEGIN SELECT * FROM dbo.Table1, dbo.Table2 WHERE Table1.Id = Table2.IdTable1 AND Table1.Name LIKE '%' + @Name + '%' END And my c# code is something like this: Database db = Databas...

where is powerdesigner?
I just read the asa-8 documentation and found out that powerdesigner can be located at: From the Start menu, choose Programs->Sybase SQL Anywhere 8->PowerDesigner 7->PowerDesigner. Somehow I couldn't find it? Is it missing from installation cd? or do i have to purchase a powerdesigner cd of its own? please advise, thx rony Its a seperate software and you need to purchase it seperately and install it. -- HTH Satish "Rony Santoso" <rony_xg@yahoo.de> wrote in message news:420cdf42@forums-2-dub... >I just read the asa-8 documentation a...

ASA 10 , need list of all primary key column name with table name
ASA 10 , need list of all primary key column name with table name Can any one tell me how to write SQL for that Table list I can get with select name from sysobjects where type = 'U' and user_name(uid) = 'dba'; but i need primary column key list associate with the table Do you want one row per primary key column, or one row per primary key with the column names in a string like 'col1, col2, col3'?, or what? Please show us an example of *exactly* what the output should look like. FWIW the LIST() aggregate function is very v...

About PowerDesigner
is PowerDesigner included in the enterprise version of PowerBuilder 6.0 or 6.5? if so, which CD is PowerDesigner in? PowerDesigner is part of the EAStudio package but not the PB stand-alone package. I believe that is still the case even today with PB8. If you get EAStudio, you get PB, PowerJ, PowerDesigner (remember that with PB8, PowerSite has been rolled into the product and doesn't exist on it's own any more). If you get just PB, you get just PB. steve [TeamSybase] Dear Steve, Now I find out EAStudio. I can see the following options for installation: Power...

PowerDesigner
How can I get the Data Dictionary in the PowerDesigner? <Ronald> wrote in message news:43E682E4B7D283D6001D2E2F85256A63.001D2E3C85256A63@webforums... > How can I get the Data Dictionary in the PowerDesigner? Wrong newsgroup. Try powersoft.public.powerdesigner.general. jb ...

The why/when of Powerdesigner.
I'm having a hard time using Powerdesigner beyond just a data-modeling tool. I'd really like to understand how to use it as a full SDLC tool. It sure looks like it can, but I don't see how to really go about it, especially in light of the fact that organizations already have SDLC standards. How do I fit PD into that lifecycle? I'd really like to learn how to generate code from it, which involves understanding how to get at the metadata and visual basic and such. I used Erwin's macro capabilities and was completely blown away by the power. Now I see PD, and I...

PowerDesigner
We are currently running PowerDesigner 6.0.0 and 6.1.1.560 on Windows NT and are planning to upgrade to Windows XP in the new year. Are these versions of PowerDesigner compatible with XP or would we need to upgrade or apply patches? They are not certified, but there shouldn't be a problem. Of course, you really should upgrade anyway to take advantage of the newer functionality. -- Michael F. Nicewarner [TeamSybase] http://www.datamodel.org mailto:TeamSybase.5.psyclo@spamgourmet.com <G>; <_Tchoryk> wrote in message news:1BBF7C8E5DA9E6CB0072529485256C4D.007...

Quoted names in PowerDesigner
I'm using the PowerDesinger which is bundled with PowerJ (I think it's called AppModeler). I have columns named 'Comment' in my data model which seems to be a reserved word in Adaptive Server Anywhere 6.0, which caused syntax errors when generating the schema on the database. To avoid this problem I added "AddQuote = YES" to the DEF-File, which solved the problem for the "CREATE TABLE"-statements. Unfortunately this causes a new problem in the "DROP TABLE"-statement, e.g: if exists(select 1 from sys.systable where table_name='"Acc...

Model from PowerDesigner 9.5 convert into PowerDesigner 8...
Folks, Happy New year! I have a problem here -- please help. I've tried new PowerDesigner 9.5 (trial version). I have opened my existing model from PowerDesigner 8, and have done some changes to it. Actually, a lot of changes... Now question, is somehow possible to read this conceptual model in PowerDesigner version 8 again? Is any converter available? Can I save my model with special flags, etc? I really need this problem to be solved since company is not looking to buy new version, and I have to find out the way to bring all my changes to lover version of PowerDesi...

Upgrade from PowerDesigner v11.1 to Powerdesigner v12.0
Hello. upgrading from PowerDesigner v11.1 to PowerDesigner v12.0 requires to uninstall v11.1 and then install v12.0 or is there an upgrade software installation ? Thanks. Best Regards. Marcello. V11 and V12 can coexist on the same system. If you leave V11 on during the V12 install, it will give you the option to retain the V11 settings in V12. This is a good thing. Then you can unintall V11 later. -- Mike Nicewarner [TeamSybase] http://www.datamodel.org mike[at]datamodel[dot]org (can you figure what to change?) Sybase product enhancement requests: http://www.isu...

Web resources about - PowerDesigner - foreign key column name - sybase.powerdesigner.general

SAP Enhances PowerDesigner, Supports 'Every Shade of Hybrid'
While doing all it can for its big-business customers, SAP has also been building out a "thoughtful"—and Millennial-friendly—SME strategy.

Data Architecture Professionals
A growing network comprising of Data/Data Warehouse/Solution Architects, IT Specialists, DBAs, Analysts, Managers, Strategists and other professionals ...

Entity–relationship model - Wikipedia, the free encyclopedia
An ER model is an abstract way to describe a database . Describing a database usually starts with a relational database , which stores data in ...

Entity-relationship model - Wikipedia, the free encyclopedia
In software engineering , an entity-relationship model ( ER model for short) is an abstract and conceptual representation of data . Entity-relationship ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
我的异常网之热门搜索专题提供权威的各类程序问题解决方案,欢迎您的到来。


Welcome - Careerlink.com
Welcome to Careerlink.com, your online resource for posting and finding jobs. Here Job Seekers can browse employment opportunities by career, ...

Sybase debuts Web tools
Sybase is continuing its comeback in the database and development tool market, debuting packages for building intranet and Internet applications. ...

SAP lays out plans to become big player in databases, mobile
SAP made a series of announcements on Tuesday as part of its bid to become a high-profile player in the database market alongside the likes of ...

Resources last updated: 11/27/2015 11:05:04 PM