Book a Demo

Author Topic: MS SQL2000 DDL script problem.  (Read 2242 times)

Vlad

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
MS SQL2000 DDL script problem.
« on: May 19, 2005, 04:53:09 am »
Hi all!
I have loaded EA 4.5 for evaluation. A very good tool. But I found a trouble with generation MS SQL2000 DDL script. I created two tables with FK reference between them. When I generated a script file I got this:

CREATE TABLE Dish (
ID_Dish uniqueidentifier identity(0,1)  NOT NULL,
ID_DishGroups varchar(255),
DishName varchar(64),  
DishKind smallint
)
;

CREATE TABLE DishGroups (
ID_DishGroups uniqueidentifier NOT NULL,
ID_Parent uniqueidentifier,
DishGroupName varchar(64)
)
;


--  Create Primary Key Constraints
ALTER TABLE Dish ADD CONSTRAINT PK_Dish
PRIMARY KEY (ID_Di)
;

ALTER TABLE DishGroups ADD CONSTRAINT PK_DishGroups
PRIMARY KEY (ID_DishGrou)
;

Why it cuts field names while primary key generation?

More over, when I change MS SQL2000 on Interbase. EA generates correct DDL script.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: MS SQL2000 DDL script problem.
« Reply #1 on: May 19, 2005, 03:42:57 pm »
This bug was fixed in version 5    :)