Re: Database Design Transformer - missing PK columns

From: Shiu W. Chee <shiuc_at_home.com>
Date: Tue, 15 Dec 1998 03:40:57 GMT
Message-ID: <dTkd2.274$EV6.108_at_news.rdc1.tn.home.com>


Your tip definitely helps. In fact, by re-examining all the key attributes, and,
relationships, I found out that's where the problem is. Thanks. pcucciolo_at_hotmail.com wrote in message <74qjg0$1cu$1_at_nnrp1.dejanews.com>...
>Hare you sure that all columns are NOT NULL? There is a foreign key
optional
>that is also in the primary key? you must change to non optional.
>
>Designer transformer don't create primary key if there is a columns NULL.
>
>Bye Pino
>
>
>
>
>In article <wb%b2.2655$1k.547_at_news.rdc1.tn.home.com>,
> "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.
>>
>>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 15 1998 - 04:40:57 CET

Original text of this message