Re: Database Design Transformer - missing PK columns

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 11 Dec 1998 13:38:47 GMT
Message-ID: <74r797$fst$1_at_relay1.dsccc.com>


I found that I had to make several passes to get the pk to become fk.

  1. create tables without any forigen keys.
  2. create tables which do not need keys from tables not already created.
  3. do step 2 until all tables are created.

Shiu W. Chee (shiuc_at_home.com) wrote:
: Our developers have created entities, attributes, and relationships.
: We tried to use Database Design Transformer to transform them
: into tables, columns, constraints. Initially, we only got the tables
: without anything. The problem was with the use of reserved words
: for some of the entities. Once we changed the names to non
: reserved words, we got the tables, columns, constraints such as
: primary keys, and, foreign keys. But then we found that for all
: the primary keys, there are no associated columns. We have
: verified that all the originating UIDs have attributes defined.
: Any idea why we cannot get the primary key columns?
: Any suggestion will be much appreciated.

To fix your problem, Delete the tables with the missing fks and start at step 2.

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.
Received on Fri Dec 11 1998 - 14:38:47 CET

Original text of this message