开发者

Embarcadero ER/Studio Physical Model generated convert the Serial to Integer

开发者 https://www.devze.com 2022-12-28 06:52 出处:网络
I created a table using ER/STudi开发者_如何学Pythono 8.0.3 ... The table has a serial pk(SERIAL/INTEGER in ER/Studio)...

I created a table using ER/STudi开发者_如何学Pythono 8.0.3 ... The table has a serial pk (SERIAL/INTEGER in ER/Studio)... But the ER/Studio Physical Model generated convert the Serial to Integer... And The generated table in database has a integer pk, without auto-increment functionality...

Any idea?

Table generated :

CREATE TABLE test ( id integer NOT NULL )

Should be :

CREATE TABLE test ( id serial NOT NULL )


ER-Studio only generates SQL-Server code, even the mySQL generated code needs manual corrections. Try Datanamic Dezign over 6.


Does not work with PostgreSQL...

0

精彩评论

暂无评论...
验证码 换一张
取 消