Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: designer 6.0 question

RE: designer 6.0 question

From: John Flack <JohnF_at_smdi.com>
Date: Wed, 17 Mar 2004 16:07:13 -0500
Message-ID: <91AFBA9B76078B4E8340A383EADEF1DB7EE572@syn2kex1.smdi.com>


The relationship never shows up as an attribute, unless you add the attribute yourself. It only shows up as a column when you run the Database Design Transformer (DDT) and convert your entities to tables and attributes to columns. There are some DDT options to control how that happens. DDT also creates surrogate PK columns and the sequences to generate them whenever you don't designate an attribute or set of attributes as the PK.

This part of Designer hasn't changed very much from 6 to 6i and 9i.

-----Original Message-----

From: jtesta_at_dmc-it.com [mailto:jtesta_at_dmc-it.com] Sent: Wednesday, March 17, 2004 3:50 PM
To: oracle-l_at_freelists.org
Subject: designer 6.0 question

Yea, I know its old but its what i'm currently having to use.

that being said, anyone on the list remember using designer 6.0. I've used ERWIN off/on for years and remember Erwin doing the following:

when creating a relationship between 2 entities and the uniq ID is already defined, the PK from the parent would migrate as an attribute to the child and show up in the child entity as an attribute. I can't seem to get designer to do that.

although if i get all the way thru and generate DDL, the column is in the create table statement for the child.

Anyone know what the heck I'm talking about?

thanks, joe



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
Received on Wed Mar 17 2004 - 15:08:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US