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

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

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