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