How to create sql DDL for SQLite


I think it is create to be able to create entities in the ERD with SQLite type, though how to I utilize that when generating SQL DDL?

The product is not clearly stating the SQL DDL being generated is MS-SQL For example the command sys.sp_addextendedproperty is generated and this is solely MS-SQL and not useable by other SQL database systems.

My question is how can I have the product create SQLite SQL if the entity is using SQLite types.

17 January 2021 22:28:52 John Ferris

Add Comment

Dusan Rodina - 18 January 2021 14:10:04


Thank you for your feedback. Currently, there is no pure SQLite SQL DDL template for script generation. The current SQL DDL generation is optimized for MS SQL server. We will add support for SQLite SQL DDL scripts and general SQL DDL scripts in the next release. It should be released soon.