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!

Open the help file and read the chapter called "Database Engineering". — chimp, Aug 12 '13 at 00:38

score 8 · Accepted Answer · answered Aug 23 '13 at 07:12

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!)

score 3 · Answer 2 · answered Apr 20 '15 at 07:33

3

After open your database diagram,

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

answered Apr 20 '15 at 07:33

Mustafa Kemal

1,292
19
24

2

Now it was moved to Package tab – Dawid D Jul 19 '16 at 22:07

score 1 · Answer 3 · answered Sep 02 '20 at 11:51

1

Select all tables from your diagram and press F11.

answered Sep 02 '20 at 11:51

tosovvoj

55
8

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

3 Answers3