Re: Database Design Transformer - missing PK columns
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.
- create tables without any forigen keys.
- create tables which do not need keys from tables not already created.
- 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