Toad World® Forums

DDL - Columns repeated


#1

I reverse engineered a db and created the DDL script for verification.

Found that the column names are repeated for all the tables IN THE ER DIAGRAM and in the DDL.

Here is an example:

CREATE TABLE [dbo].[TTOPMTP_MTH_PRD]
(
[MM_SK] Decimal(6,0) NOT NULL,
[MM_SK] Decimal(6,0) NOT NULL,
[YR_NB] Int NOT NULL,
[YR_NB] Int NOT NULL,
[MM_NB] Char(2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MM_NB] Char(2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

Not sure if this is a bug that has been reported already.

How do I fix this?

Thank you
MA

Message was edited by: Modeler Amateur


#2

Hi,

can you send us the model to modeling@quest.com please? The model will be used for testing purposes only. Also, please write us more information about how you established a connection to your DB (database, version, connection method etc.)

Regards,

Vaclav


#3

The next time I encounter this problem, I’ll save and send you details.

Thank you for your response to my question.

I tried to reverse engineer today but it worked fine this time ( I forgot to save the old model)


#4

Hi,

OK, thanks.

Regards,

Vaclav