Sparx Systems Forum
Enterprise Architect => Suggestions and Requests => Topic started by: kalbun on December 27, 2004, 04:39:23 am
-
I'm using EA to generate tables for sqlite.
After some minimal work in the "database datatype" dialog box, I can generate SQL scripts to create tables.
There is a problem, yet, related with the creation of primary keys.
Indeed uses ALTER TABLE to add a constraint to the primary key, while sqlite uses a different syntax (appending PRIMARY KEY after the field definition).
This means that scripts must be modified by hand and then executed with sqlite. It would be great if this issue could be addressed in a future release.