TABLE 1: Comparison of PowerDesigner 9.0 and SQL Server Data Types
PowerDesigner 9.0 SQL Server Equivalent
A2 char(2)
BL bit
D or DT datetime
DC5,2 dec(5,2)
I integer
IDENTITY Domain defined on a long integer with auto-numbering capability; start at 1, increment by 1.
LI long integer
MN money
N8,2 numeric(8,2)
VA10 varchar(10)