Need to export SQL for creating table(s) from Enterprise Architect

Question

I need to create SQL statements from Enterprise architect v.9 table description, since I need "CREATE TABLE" to be placed in a text file.

Please advice me where to look in EA interface!

Answer 1

In the diagram where your tables are designed, select all of them and right click in one of the tables. Look for SQL Code Generation and choose one of the options: single DDL script or not.

The difference is that in the single script all create table statements will be generated in only one file (which is usually better!)

Answer 2

After open your database diagram,

1. Look at Tools tab and expand Database Engineering menu,
2. Select Generate Package DLL,
3. Enter output file name and generate it.