Re: ERwin character generation

Column order is unimportant. And ERwin has a history of writing "interesting" SQL. If you are using version 3.5 see whether you are defining your columns in the LOGICAL or the PHYSICAL window.

It is always best with ERwin to have it create the SQL as a text file and then proof-read and edit it.

Daniel A. Morgan

Jplahman wrote:

> Hi:
>
> I'm new to ERwin, so please be patient.
>
> I've designed a table with the following columns:
>
> LimitCode: Char(20)
> LimitType: Char
> LimitName: Char(20)
> HoldUse: Char
> Aim: Float
> MinTol: Float
> MaxTol: Float
>
> LimitCode and LimitType form the primary key.
>
> When ERwin generates the table, the order of the table is: LimitCode,
> LimitName, LimitType, HoldUse, Aim, MinTol, MaxTol. Why does ERwin do this?
>
> Thank you
>
> Jim
> JPL
Received on Mon Jun 21 1999 - 16:44:17 CDT