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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Transformer Puzzle in Rel 2.1 of Designer 2000

Re: Database Transformer Puzzle in Rel 2.1 of Designer 2000

From: Mark Kramm <mkramm_at_worldnet.att.net>
Date: 1998/10/20
Message-ID: <70ijhs$383@bgtnsc03.worldnet.att.net>#1/1

in the Database Design Transformer, Run Options tab select Settings on the keys tab, uncheck "Create surrogate keys for all new tables".

IHTH's

Mark A. Kramm

Look at http://www.odtug.com for list server groups for Designer/2000 and other products. It is the bext!!! I know i am a board member.

Nicholas Wakefield wrote in message
<70hrg3$gbk$1_at_mendelevium.btinternet.com>...
>I have two versions of designer in my office 2.1 and 1.3.2 and when I
 create
>an application
>with the entity realtionship model like the one below, I get two completely
>different answers
>_________ _________
>| Entity A | | Entity B |
>|________| |_________|
> | |
> | |
> | |
> : :
> : :
> _:_ _:_
> /|\ /|\
> _ /_|_\ _______/_|_\_
> | Entity C |
> |________________|
>
>1.3.2 - Creates two new foreign key columns in entity c, which form the
>primary key - which is what I want, when put through the database wizard.
>...Whilst ...
> 2.1 - Creates a sequence identifier(surrogate) for the primary key and
>two optional foreign key columns entity c, when put through the database
>transformer.
>
>Could someone please tell me why as it has got me baffled.
>
>Regards
>Nicholas
>
>
Received on Tue Oct 20 1998 - 00:00:00 CDT

Original text of this message

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